Witango-Talk: Arrays appearing instead of variables

[James Macfarlane]

Title: Message

I have a query that just started misbehaving. I was getting a SQL error, so I dumped the value of the SQL statement and here's what I got: SELECT DISTINCT P1.planId,P1.planName,P1.carrierId,P1.planImage,P1.planMSF FROM dbo.Plans P1,dbo.PlanProvince P2 WHERE (P1.planStatus=1 AND P1.carrierId in (2, 1, 4) AND P2.provinceId in (1, 2, 7) AND P1.planId in ( 30 25 11 14 ) AND P1.planId in (8, 9, 11, 12, 13, 14, 15, 16, 17, 21, 26, 29, 30, 32, 35, 39, 40, 41, 42, 52, 53, 54, 55)) AND ((P1.planId *= P2.planId)) ORDER BY 2 ASC  Why is my array appeading as an HTML array instead of a comma-separated list of variables, as it is in other parts of the query?!?!?!? The code hasn't been touched in weeks and it all of a sudden it started doing this. Wev'e had to change the code to set the variable as a string by looping through the resultset instead of just passing the resultset as a variable. - James.