Forums

This topic is locked

passing multiple item to a confirm page

Posted 28 Oct 2001 12:23:33
1
has voted
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/

Reply to this topic