Command with parameters and IN SQL operator

  • Thread starter Thread starter Frédéric Mayot
  • Start date Start date
F

Frédéric Mayot

Hi,
It seems that this code does not work, what's wrong ??
dim s as string = "SELECT * FROM sometable WHERE somefield IN (@stuff)" '
where somefield is an int
dim cmd as new command
dim arr() as integer
[...]
if arr.length > 0 then
cmd.parameters.add(new sqlparam("@stuff", arr))
[...]
end if
 
Hit the archives for this one. It's been discussed a dozen times. (google
groups)

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Sorry, I've already tried many google queries but I didn't find anything...
 
Back
Top