Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-10-21 : 07:54:49
|
| Tom writes "I've written a ASP.NET app that allows the user to select multiple values from a listbox and then passes those selections to the database as a parameter in a stored procedure. I had hoped to then take those values and insert them in a WHERE IN statement to help filter the record set. Unfortunately, no matter how many ways I try to trick out the WHERE IN statement, it just won't take more then one value. I have also hard coded multiple values and that works fine, so I know the problem is not anything with the overall syntax. This is a real stumper for me and various manuals and web sites just don't cover it. Can you help me SQL Guru?" |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-10-21 : 09:21:54
|
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=6134Go with the flow & have fun! Else fight the flow  |
 |
|
|
jhermiz
3564 Posts |
Posted - 2005-10-21 : 19:47:12
|
That has got to be the most asked about question on the forum.
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
|
|
|
|
|
|
Passing multiple values to WHERE statement using a PARAMETER