RE: Witango-Talk: IS IN screws up

[Tom Ferguson]

Nevermind, I looked at your screen shot.  Looks like it generated the SQL statement without the trailing ) -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Tom Ferguson Sent: Friday, December 06, 2002 3:11 PM To: Multiple recipients of list witango-talk Subject: RE: Witango-Talk: IS IN screws up Aren't you missing a trailing right paren? -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of James MacFarlane Sent: Friday, December 06, 2002 2:59 PM To: Multiple recipients of list witango-talk Subject: Witango-Talk: IS IN screws up Every once in a while I go to use a query action that uses and IS IN clause like this:   SELECT M1.planVariantId FROM dbo.MassPriceLookup M1 WHERE (M1.priceGroupId=1 AND M1.VariantId in (11,11,2,2,3,3,30)   Get a syntax error, so I have the application dump out the SQL statement and it looks like this:   SELECT M1.planVariantId FROM dbo.MassPriceLookup M1 WHERE (M1.priceGroupId=1 AND M1.VariantId in ( 11 11 2 2 3 3 30 )   So instead of dumping in comma-separated values, it puts in the HTML table of values. Why?!?!?!   I’ve included my screenshot of the query         ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body