[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 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
