Re: [mv] Multiple database usage question

[Ryan Hertz <rhertz@gyb.baits.com>]

******    message to minivend-users from Ryan Hertz <rhertz@gyb.baits.com>     ******

At 01:05 AM 1/6/2000 , you wrote:
>******    message to minivend-users from John Foster 
><jfoster@augustmail.com>     ******
>
>I have read that MiniVend 3.14 can utilize multiple databases per
>catalog. The instructions listed in the MV documentation does not give
>much detail other than the fact that it is possible, referencing
>"Arbitrary Databases". I have also read ALL of the references in the
>mail list archives without finding the answer to my questions.
>
>I want to be able to use 4 discreet tab delimited ascii text databases
>including the products.asc file. I need to have the search engine locate
>a selection of products and display them from the products.asc file:
>from the displayed products the customer can select to buy or for more
>information. If more information is selected the search engine would go
>to another database and pull up facts regarding the particular item
>being surveyed. It would then use the information to fill out a pre
>designed fact sheet. The field arrangements of the tables are quiet
>different between these databases.


Here's how I retrieve articles that are keyed (product) under my 
[item-code] from another database (articles.asc).

[loop search="fi=articles.asc/sf=product/se=[item-code]/ml=12/co=yes"]
<small>Related article: <A HREF="[loop-data articles url]" 
TARGET=inside>[loop-data articles title]</A></small><BR>[/loop]

I think that multiple databases are explained very well in the docs:
[data base="another" field="moredescription" key="[item-code]"] should work, or
[item-data another moredescription] would eval to the 'moredescription' of 
the current item-code in database 'another', etc...

TMTOWTDI



>EXAMPLE products.asc:
>code model vendor description price
>0001  12    intel    cpu       1.00
>0002  38    asus     MBoard    2.00
>
>EXAMPLE specs.asc
>code  model  attribute1  attribute2
>0045   12      500mhz     MMX
>0046   12      3.5 volt   w/fan
>0047   12      Slot2      PentiumIII
>
>These examples are very simplified compared to the actual databases, but
>you get the idea. Both databases are quite large. The other databases
>are also not similar to products.asc. They are to be accessed in the
>same manner as the specs.asc but are for providing information relative
>to the various categories of products and the different manufacturers.
>
>My question is, has anyone done this or anything similar and if there
>are any other docs regarding this. If not I am certainly interested in
>any tips or suggestions. ANY help is appreciated.
>--
>AdVance-Computing Systems
>
>We sell fine quality servers and workstations.
>We specialize in multiprocessor units.
>We install Debian Linux at no extra charge!
>
>John Foster
>jfoster@augustmail.com
>ICQ# 19460173
>-
>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


Ryan Hertz                                              tel  800-645-BAIT
Webmaster                                               fax  520-645-2588
Advertising Director                            http://www.insideline.net
Gary Yamamoto Custom Baits, Inc.            http://www.yamamoto.baits.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