Hi,
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
)
Is this in a DirectDBMS action or search action?
Eric
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
