[ic] arbitrary data base

[Ed LaFrance]

At 12:57 PM 07/09/2001 -0400, you wrote:
>See New Question BELOW
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> >Sorry for the newbie question but ....
> >
> >I've got 2 main databases I'm using. The BASE products database and a
> >details database.
> >PRODUCTS
> >  <<...>>
> >
> >DETAILS
> >  <<...>>
> >
> >
> >The results will give the description and SKU number but when they click
>the
> >SKU I want to be able to access the DETAILS database to pull the song
> >listing for that SKU
> >and let them order from there.
> >
> >I can't figure out how to display the results I need from the details
> >database.
> >
> >Sorry if this is a vague question and thanks in advance for the help.
> >using GDBM
>
> >>On flypage.html:
> >>
> >>[item-data details field_1]
> >>[item-data details field_2]
> >>...etc
> >>
> >>
> >>The syntax for retrieving info for the current item ([item-code]) from an
> >>arbitrary data base is [item-data table field].
> >>
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
>QUESTION / PROBLEM
>"The syntax for retrieving info for the current item ([item-code]) from an
>arbitrary data base is [item-data table field]."
>
>It seems that it IS reading the Details Database because I have non-tagged
>characters seperating the tags and it will list the correct number of items
>it SHOULD display but it is NOT displaying the results.
>
>The code that is calling it is:
>[item-data songs.txt track]:<b>[item-data songs song]-[item-data songs
>artist]<br>
>
>Each SKU has 6 listings and on the display I am getting:
>:-
>:-
>:-
>:-
>:-
>:-
>
>I want to use the SKU field from the Products Database to match up to a
>secondary field in the DETAILS Database. The details database will have
>multiple lines for 1 SKU each with a unique ID as the key. I then want the
>listings to appear on the SKU that is passed.
>
>Here are the databases and the field names:
>PRODUCTS
>sku     description     title   template_page   comment display image
>price   wholesale       category        nontaxable      weight  size
>color   gift_cert       related featured        download        dl_type
>dl_location     inactive
>
>DETAILS
>songkey sku     track   song    artist  title   time    key
>
>What would the proper syntax for a loop or search to return the listing
>using the [item-data table field] tags?
>
>Thanks again for the advanced help!!

It's a secondary search:

[search-list]
....
[loop search="
         fi=details
         st=db
         sf=sku
         se=[item-code]
         tf=track
         to=n
         ml=1000
"]
[loop-data details track]
[loop-data details song]
...
[/loop]
...
[/search-list]



- Ed L



===============================================================
New Media E.M.S.               Software Solutions for Business
463 Main St., Suite D          eCommerce | Consulting | Hosting
Placerville, CA  95667         edl@newmediaems.com
(530) 622-9421                 http://www.newmediaems.com
(866) 519-4680 Toll-Free       (530) 622-9426 Fax
===============================================================