smerkel
|
| Posted: 02/12/2003, 7:31 AM |
|
I am using ccs2 with ms access.
If I select more than one option from a multiselect list box on a search form, my results grid will not return the matching records. I can not figure out why this is not working correctly. Could someone please, please provide me with a suggestion or an example to make this work!? Thanks very much!
|
|
|
 |
Mehmet Ozdemir
|
| Posted: 02/12/2003, 1:12 PM |
|
Assuming your using ASP Response.Write and Response.End, learn to use them. They can help in situations like this. By Response dot writing the Form item for your multiselect list box you will notice that the multi selected items are comma delimited, eg
Response.Write Request.Form("s_ID")
Response.End
2, 3, 4
that this point based on the default query builder sql statement the script will simply substitute 2, 3, 4 in the place holder of the sql statement ie {s_ID}. You will either need to parse this returned value or use an IN clause instead of just WHERE ID = {s_ID} eg: WHERE ID IN({s_ID}). I have
|
|
|
|
|
