Multi Select List box

[greekchild]

Hi, I'm hoping someone can help. I have a dynamic multiselect menu. When a
user selects more than one of the options, I am trying to pass in the multiple
values into a recordset variable. I can pass in a normal dropdown listbox as
a variable but how do I use multiple values in a where statement. select *
from user where user_id in ('Parameter') Any help is much appreciated. Thanks
Con

[Chris In Madison]

Are the values you are passing numeric or text-based?

Best regards,
Chris

[greekchild]

Hi Chris,

The values I am passing are numeric. The menu list value is an id and the lable is text.

Thanks

Con

[Chris In Madison]

Then this should be pretty easy. Not sure which server model you're using,
but I'm going to do this in ASP in this example.

When you create your recordset definition, create a parameter with any name
you like ("intUserList" for example). Then, for the default value, use -1
or something you know won't return any values, and for the Run-Time Value,
use Request("name_of_list_box").

For your query use:

select * from user where user_id in (intUserList)

Dreamweaver should fix up the query so the resultant code will look like
this:

"select * from user where user_id in (" +
Replace(Request("name_of_list_box"), "'", "''") + ")"

So, if you select only one item in your list box, the resultant SQL would be
(for example)::

select * from user where user_id in (2)

And if you select more than one item, the resultant SQL would be (for
example):

select * from user where user_id in (2, 4, 6, 8)

That should do the trick (hopefully!)

Best regards,
Chris

[greekchild]

Hi, Thanks for the reponse but unfortunately it didn't work. Request('listbox')
won't work so I tried request.form('listbox') and
request.querystring('listbox') It only does the sql statement with the first
option you select in the listbox. e.g if you select 3 items it still only adds
1 in the sql statement. Cheers

[Chris In Madison]

really? That's weird...

Let me do some tests and I'll get back with you...

~Chris