Re: [mv] How to use/search fields from different databse files ?

["Tal Hart (TelNET)" <tal@telnet.co.il>]

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