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

[".cory.trese." <digital@specialty-books.com>]

******    message to minivend-users from ".cory.trese." <digital@specialty-books.com>     ******


This will probably be a "loop search."  At least it probably will be if you
decide try what you're talking about.  Can't see how it would go any other
way...

)>Now , i would like to make a search (one line search)
)>for all of this week's specials.

[loop search="fi=specials.asc/ra=yes"]
[sort products:category]      <--------- could be SO wrong *
[loop-code]
[loop-data products description]
[loop-data special special_price]

...and so on.

(* this may be the incorrect syntax to use within a [loop-search] tag, but I
know a tag for [loop-search] can be made to work, since I've done it in the
past. )

You can use the "[loop-data]" tag to :

[loop-data database fieldname]
Evaluate to the field name FIELD NAME in the arbitrary database table database,
for the current item.  Using this tag you should be able to spread your
products database over an arbitrary number of files (not that this is a _good_
idea performance wise!)

The example above is extracted from the mv 3.14-5 manual (since I'm not sure
what ver. you are using) but the same concepts are definitely available in 4.02


)>
)>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
--
--digital@specialty-books.com
800.466.1365-ext223
(cory trese)
-
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