Using parameters in the IN clause in a SelectCommand

  • Thread starter Thread starter Thomas Hill
  • Start date Start date
T

Thomas Hill

I am having a problem with a SelectCommand Parameter value. The SQL text
includes something like

"...AND TRANSCRIPT_ID IN (@IDLIST)...."

Placing an appropriate string in the Parameter collection value for this
parameter (say, "'TH'" - note the single quotes) fails to return any rows,
yet the same statement in the Query Analyzer works fine. Is there some
trick to putting paramterized values into an 'IN' clause?
 
It can't take a Parameter from ADO. See the archives for a more detailed
explanation.

--
____________________________________
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.
__________________________________
 
Back
Top