Take your @Filter command and assign it to a new variable, then you just pull out the values of the new varable, which will be an array.
BTW - Having six productID fields in a record sounds like a poor database design. It is preferable to have one ProductID field and six records. It's easier to query and leave room for expansion beyond six items. It also makes your programming easier because you can run a loop through the results and refer to the same field each time, as opposed to having to check each of the six fields. - James -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Fogelson, Steve Sent: Tuesday, July 16, 2002 4:15 PM To: Multiple recipients of list witango-talk Subject: Witango-Talk: Array challenge I have a parts look-up catalog. I have a table of "products" and each row has an id, name and link field. I then have a table of "models" and each row has an id, description, and 6 "products" id fields. I want the user to be able to select a model or a range of models. The result would list each model description and the 6 "products" id fields. My problem is I want each "products" id to be displayed as the "products" name and the "products" name should link to the "products" link. I setup up an array called Products of all the rows in the "products" table. I then thought I could use the <@FILTER> tag to select the correct "product" row. <@FILTER ARRAY="Products" SCOPE="User" EXPR="#1 = <@COLUMN 'Model.Mod_Mag_4_ID'>"> It does this correctly, but it displays a html table of the result. I need to be able to extract the 1st and second fields. Second field to display and the 1st for the link. This needs to be completed 6 times for each model. Is there a way to get this info from the <@FILTER> tag or is their a better way to do this? This method possibly might consume a lot of server resources. Thanks Steve Fogelson Internet Commerce Solutions ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
