Witango-Talk: IS IN screws up

Fri, 06 Dec 2002 12:08:55 -0800

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

Attachment: IsInError.gif
Description: Binary data

Reply via email to