Forums
This topic is locked
passing multiple item to a confirm page
28 Oct 2001 12:23:33 jon badda posted:
Im needing to get multiple selected items (with a checkbox) to be displayed on a confirmation page.What I have atm is: the checkbox is the ProductID, the ID is sent to the confirm page where a recordset is filtered by the ProductID and the UserID.
except im getting a comma error...
is there another way of doing this?
Replies
Replied 29 Oct 2001 15:06:20
29 Oct 2001 15:06:20 Joel Martinez replied:
Hmm, I wonder if you're using the correct SQL syntax... it should be<pre id=code><font face=courier size=2 id=code>SELECT * FROM products WHERE ProductID <b>IN (mm_requestProdID)</b> ...</font id=code></pre id=code>since you're using a checkbox, the result from the request("productID" is going to be a comma delimited string of all the values. this, I think, is where your error occurs.
Joel Martinez [ ]
----------
E-Commerce Concepts with Ultradev...pre-order yours at
www.basic-ultradev.com/ecomm_concepts/
Joel Martinez [ ]
----------
E-Commerce Concepts with Ultradev...pre-order yours at
www.basic-ultradev.com/ecomm_concepts/