>>>>>>
>>>>>>I think Sergey nailed it, but now it's not clear how to set multiple parameters?
>>>>>
>>>>>Set them in the order they will be used
>>>> Parameters(1) ?
>>>>Parameters(2) ?
>>>The SQL statement should be something like 'Select from x where y=? and z=?' . The question marks will be replaced by the parameters in the order in which they were added in .NET
>>
>>I still don't understand exactly, can you post a quick sample?
>
>
http://www.west-wind.com/WebLog/posts/660586.aspxThanks a lot - very clear.
If it's not broken, fix it until it is.
My Blog