MiniVend Akopia Services

[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 &quot;[data base='articles'
field='title' key='[item-code]']&quot;</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


Search for: Match: Format: Sort by: