Quote value should be Yes.
Stefan
At 04:38 PM 7/3/2002 -0400, you wrote:
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.
Database WebWorks: Dynamic web sites through database integration
http://www.DatabaseWebWorks.com
