[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: [mv] How to use/search fields from different databse files ?
****** message to minivend-users from "Tal Hart (TelNET)" <tal@telnet.co.il> ******
Thanks,
will test ... on thursday though....
will update everyone..
Tal.
----- Original Message -----
From: <minivend-users@minivend.com>
To: <minivend-users@minivend.com>
Sent: Tuesday, March 14, 2000 10:05 PM
Subject: Re: [mv] How to use/search fields from different databse files ?
> ****** message to minivend-users from Ed LaFrance
> <edlafrance@printexusa.com> ******
>
> Tal -
>
> What you actually need to do is search your specials file (or just list
> it's entire contents using [tag loop each]), and pull in the appropriate
> data from the other "related" files as needed. The results page search
> list would look something like this:
>
> [search-list]
> [item-code]
> [item-data desc description]
> [item-data products category]
> [item-data specials price]
> [/search-list]
>
> This is untested. I am not sure of the syntax. You may need to use [data
> database::column::[item-code]] syntax for retrieving data from outside the
> specials file instead. You will also need to set up your special pricing
> so that minivend uses it instead of the products::price column. But this
> is the basic idea.
>
> - Ed L>
>
>
>
> At 08:00 PM 3/14/00 +0200, you wrote:
> >>****** message to minivend-users from "Tal Hart (TelNET)"
> >><tal@telnet.co.il> ******
> >>
> >>Thanks for the reply,
> >>I use MV 4.01,
> >>and the situation is that i am not searching for different products in 3
> >>difefrent databases....
> >>The same Product is split into 3 different databases,
> >>For instance :
> >>I have a DB called 'Specials' Which I generate and it includes a Product
> >ID
> >>, and a special price for this week only.
> >>
> >>Now , i would like to make a search (one line search)
> >>for all of this week's specials.
> >>
> >>The results should be the list of these 10 items,
> >>sorted by lets say category, with their descriptions...
> >>
> >>The 'special' DB only contain the Prod ID and special Price...
> >>The category is a field within the products DB,
> >>and the Description, is a field in the 'desc' DB.
> >>
> >>All field correspond to the same Prod' ID...
> >>
> >>Would the previous reply be apropriate for this situation ?
> >>
> >>Tal.
> >>
> >>----- Original Message -----
> >>From: <minivend-users@minivend.com>
> >>To: <minivend-users@minivend.com>
> >>Sent: Tuesday, March 14, 2000 6:20 PM
> >>Subject: Re: [mv] How to use/search fields from different databse files
?
> >>
> >>
> >> > ****** message to minivend-users from Ed LaFrance
> >> > <edlafrance@printexusa.com> ******
> >> >
> >> > Tal -
> >> >
> >> > This is from the 3.1x docs (you didn't mention what mvend version you
> >are
> >> > using):
> >> >
> >> > -------
> >> >
> >> > mv_search_file
> >> > In the text search, set this variable to the file(s) to be
> >scanned
> >> > for a match. The default,
> >> > if not set, is to scan the products.asc file. If set multiple
> >times
> >> > in a form (for
> >> > a text search), will cause a search all the files. One file
> >name
> >> > per instance.
> >> >
> >> > In the Glimpse search, follows the Glimpse wildcard-based file
> >name
> >> > matching scheme. Use
> >> > with caution and a liberal dose of the Glimpse man page.
> >> >
> >> > ---------
> >> >
> >> > So my understanding is that, within your search form:
> >> >
> >> > ...
> >> > <input type=hidden name=mv_search_file value="File_1">
> >> > <input type=hidden name=mv_search_file value="File_2">
> >> > <input type=hidden name=mv_search_file value="File_3">
> >> > ...
> >> >
> >> > I have not tried it myself. Let us know if it works!
> >> >
> >> > - Ed L.
> >> >
> >> >
> >> > At 04:40 PM 3/14/00 +0200, you wrote:
> >> > >>****** message to minivend-users from "Tal Hart (TelNET)"
> >> > >><tal@telnet.co.il> ******
> >> > >>
> >> > >>Our database is plit into 3 different files,
> >> > >>Each file have the SKU (Prod ID) , and some information,
> >> > >>I.E. File 1 , have description
> >> > >>File 2 have Category
> >> > >>and File 3 Have pricing.
> >> > >>
> >> > >>How can we use/search/sort these 3 files,
> >> > >>as if they were one .....????
> >> > >>
> >> > >>
> >> > >>Tal Hart
> >> > >>=============================================================
> >> > >>TelNET Communication
> >> > >>Tel # + 972-9-8859919 Fax # +972-9-88598929
> >> > >>Address : Office - 10 giborey israel, New industrial area,Netanya
> >> > >>Post Adress : 2 Gur st. , Ramat Poleg , Netanya , ISRAEL , 42000
> >> > >>E-mail : tal@telnet.co.il Web : www.telnet.co.il
> >> >
> >>
> >>-
> >>To unsubscribe from the list, DO NOT REPLY to this message. Instead,
> >send
> >>email with 'UNSUBSCRIBE minivend-users' in the body to
> >Majordomo@minivend.com.
> >>Archive of past messages: http://www.minivend.com/minivend/minivend-list
>
> Printex Marking Technologies
> 12113 Kirkham Rd.
> Poway, CA 92064 U.S.A.
> 858-513-2418
> 800-982-1928
> 858-513-2419 FAX
> http://www.printexusa.com
>
> -
> To unsubscribe from the list, DO NOT REPLY to this message. Instead, send
> email with 'UNSUBSCRIBE minivend-users' in the body to
> Majordomo@minivend.com.
> Archive of past messages: http://www.minivend.com/minivend/minivend-list
>
-
To unsubscribe from the list, DO NOT REPLY to this message. Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list
