Nope. There aer three arrays used in the querym, all in the IN() statements. For some onknown reason one of the arrays apears as an HTML table in the query instead of comma-separated values.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Mike Tyranski Sent: Wednesday, July 03, 2002 4:52 PM To: Multiple recipients of list witango-talk Subject: Re: Witango-Talk: Arrays appearing instead of variables Did your tango config change for aPrefix, aSuffix, cPrefix, cSuffix, rPrefix and rSuffix by any chance? The default setting is to have it print arrays out in the table format you see below. Mike James Macfarlane 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. > ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
