[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Arbitrary Database Problems
****** message to minivend-users from Mike Lerley <mike@bfent.com> ******
I have searched the archives but nothing quite mentions this problem.
I have a database of music where different forms of the same product
(tape, CD, etc) have the same item code with a .1, .2, etc. appended. I
created a separate product index (prodindex) for searching that contains
only the unique item codes. Otherwise I get multiple returns in the
search for each form of the product. So I set up my search page to
search prodindex.asc. Works great. Returns the right number, etc. Now
I want to build my results page so that it references prodindex.asc for
the title, artist, etc. info rather than products.asc. But it's not
working. I get no results whatsoever from my [data .. ] tag. What am I
doing wrong? Specifics follow.
catalog.cfg
Database prodindex prodindex.asc TAB
results.html
[search-list]
...
[data prodindex title [item-code]]
...
[/search-list]
I know that the item-code is there, because it was just used to generate
the results page!
Interestingly, the following code works fine in place of the [data] tag
above:
[data products title [item-code].2]
Sadly, it does me no good. (The .2 is necessary to make a match with
the product data)
First few lines of products.asc:
code labelabbr label distributor catalog configuration
artist title category
category2 category3 rating price list upc oldupc
old availdate
discontdate returnby specialord changecode orderid
availeast availwest
description albumid
ABK1268.2 ABK ABKCO POLYGRAM GROUP DISTRIBUTION 1268
2 ROLLING STONES
ROCK & ROLL CIRCUS 2 500 999 12.99 17.98
1877112682
10/15/96 N A RXXX241503C 3
3 "This release takes
the listener back to London circa 1968, when and where the music scene
was really happening.
People talk about Seattle and Minneapolis - ha! Check out the line-up
for this
once-in-a-life-time show hosted by The Rolling Stones: Jethro Tull, The
Who, Marianne Faithfull,
Taj Mahal, Dirty Mac, Yoko Ono and a special introduction by John
Lennon. This historic show
captured the spontaneity and communal spirit of an entire era."
R 241503
ABK6267.1 ABK ABKCO POLYGRAM GROUP DISTRIBUTION 6267
1 ROLLING STONES
MORE HOT ROCKS 2 10.75 15.98
1877162671
5/22/90 5/22/90 Y A RXXXX48248G 3
3 R 48248
First few lines of prodindex.asc:
code labelabbr label distributor catalog configuration
artist title category
category2 category3 rating price list upc oldupc
old availdate
discontdate returnby specialord changecode orderid
availeast availwest
description albumid
ABK1268 ABK ABKCO POLYGRAM GROUP DISTRIBUTION 1268 2 ROLLING STONES ROCK
& ROLL CIRCUS 2 500 999
12.99 17.98 1877112682 10/15/96 N A RXXX241503C 3 3 "This release
takes the listener back to
London circa 1968, when and where the music scene was really
happening. People talk about Seattle
and Minneapolis - ha! Check out the line-up for this
once-in-a-life-time show hosted by The
Rolling Stones: Jethro Tull, The Who, Marianne Faithfull, Taj Mahal,
Dirty Mac, Yoko Ono and a
special introduction by John Lennon. This historic show captured the
spontaneity and communal
spirit of an entire era." R 241503
ABK6267 ABK ABKCO POLYGRAM GROUP DISTRIBUTION 6267 1 ROLLING STONES MORE
HOT ROCKS 2 10.75 15.98
1877162671 5/22/90 5/22/90 Y A RXXXX48248G 3 3 R 48248
Am I missing something?? I keep wondering if I need to specify which
field is the key for the arbitrary database but the documentation
implies it is always the first one... please help!
-mike
--
Mike Lerley, System Integrator
Goold Health Systems
24 Stone Street
Augusta, ME 04330
Email mike@bfent.com
Phone (207) 622-3298
Fax (207) 623-5125
-
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
