[ic] arbitrary data base

[Rodney Wallin]

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

~~~~~~~~~~~~~~~~~~~~~~~~~~
Rodney Wallin
Sound Choice
14100 South Lakes Drive
Charlotte, NC  28273

http://www.soundchoice.com