WHERE IN parameter

  • Thread starter Thread starter Gary B
  • Start date Start date
G

Gary B

I saw an old thread here that said that ado.net does not support parameters
for the where in clause in stored procedures. However, I am trying to
supply a parameter for the where in clause from my vb.net program and it
won't seem to work.

The string I build has the following: ('california', 'oregon') but when I
look at it in the SQL Profiller it says (' ' california ' ', ' 'oregon' ') -
it's got extra single quotes. When I construct the string with no quotes at
all it goes through that way. neither works.

Should this work or are parameters not supported for where in at all?
Thanks,
Gary
 
Hi,

It is not .NET problem. It is limitation of SQL syntax when you cannot use
any parameter for IN clause. You would need to build your SQL statement
dynamically
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adobe "Wrong type parameter supplied to a PDS procedure" 0
use of 'IN (...)' on a where clause and parameters 3
WHERE IN() with parameters 23
DataAdapter Parameter question 5
Add query with parameter to tableadapter ? 1
IN query parameter 3
Reusing parameters 2
parameters in search 4

Back
Top