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
