[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
loop search mv3.10 looping through multiple fields
I'm trying to pull all matches on the current [item-code] from an external
database where the key field is [item-code] and loop on all the matches.
Here's my flatfile TAB delimitted:
code related title
93-20 (href here) Lake Keowee Yields South Carolina Record Spot
93-20 (href here) Todd Woods: My Inside Line Experience
(Notice, the codes are not unique.)
Here's the code in question:
[loop arg="[data base='articles' field='related' key='[item-code]']"]
<A HREF="[loop-code]" TARGET=inside>Read "[data base='articles'
field='title' key='[item-code]']"</A>
[/loop]
When [item-code] is 93-20, only the first db entry is returned...
naturally. Is there a way to return both lines?
I've tried [loop search="fi=articles/sf=0/se=[item-code]] without luck.
(Returns null)
Perhaps I have a logic problem here?! I'm trying to match an item to a
related magazine article. Each product relates to multiple/different
articles, each article relates to multiple/different products!
I could potentially have each code for the articles.asc file have its own
entry, and have a comma seperated list of HREFS and Titles, but I don't
know how to loop through more than one field. How could I get the second
entry in the 'title' field when I'm on the second entry in the 'related'
(href) field?
Ryan Hertz tel 520-645-3812
Webmaster tel 800-645-BAIT
Advertising Director fax 520-645-2588
Gary Yamamoto Custom Baits, Inc. http://www.yamamoto.baits.com