should be a single row/many columns rather than single column/many rows.
If you transpose your array, does that make a difference?
Stefan
At 02:58 PM 12/6/2002 -0500, you wrote:
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?!?!?!
Ive 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
Database WebWorks: Dynamic web sites through database integration
http://www.DatabaseWebWorks.com
