[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
RE: loop search mv3.10 looping through multiple fields
I have found that text databases work best when there are no duplicate
entries in column zero and when the records are sorted by column zero. I'd
recommend making code unique and adding another field to associate records
in the way you want. Or extend the code like:
code related title
93-20-01 (href here) Lake Keowee Yields South Carolina Record Spot
93-20-02 (href here) Todd Woods: My Inside Line Experience
Then you could use a combo of mv_substring=yes and mv_begin_string=yes to
just match the first 5 chars in code.
Christopher Thompson
> -----Original Message-----
> From: owner-minivend-users@minivend.com
> [mailto:owner-minivend-users@minivend.com]On Behalf Of Ryan Hertz
> Sent: Monday, June 21, 1999 8:08 PM
> To: minivend-users@minivend.com
> Subject: loop search mv3.10 looping through multiple fields
>
>
> ****** message to minivend-users from Ryan Hertz
> <rhertz@gyb.baits.com> ******
>
> 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
-
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
