Command with parameters and IN SQL operator

[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

 

[William \(Bill\) Vaughn]

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.
__________________________________

 

[Frédéric Mayot]

Sorry, I've already tried many google queries but I didn't find anything...

 

[Cor Ligthert]

Frédéric Mayot"

Sorry, I've already tried many google queries but I didn't find

anything...

Did you see this ones?

http://groups.google.com/groups?hl=...roup=microsoft.public.dotnet.framework.adonet

There are some as Bill said.



However when yuo have questions about it feel free to reply.

Cor