slap an @TRANSPOSE in there, and if it works then there's your answer... ----- Original Message ----- From: "James MacFarlane" <[EMAIL PROTECTED]> To: "Multiple recipients of list witango-talk" <[EMAIL PROTECTED]> Sent: Friday, December 06, 2002 3:45 PM Subject: RE: Witango-Talk: IS IN screws up
> Hi Eric, > > I'm just using a standard query object. My array is 1 column. You're right, > most of the time it manages to figure it out. > > I think Stefan may be onto something - I have a column full of multiple > values, instead of a row with multiple columns. > > I wish I could predict when this is going to misbehave. > > - James. > > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Eric Weidl > Sent: Friday, December 06, 2002 4:17 PM > To: Multiple recipients of list witango-talk > Subject: Re: Witango-Talk: IS IN screws up > > Hi, > > >Because the default array to text conversion is to an html table... > > Normally the standard Search action is smart enough to convert an array to > the proper comma-delimited syntax for an IS IN clause. I don't think a > DirectDBMS is that helpful however. If it is a DirectDBMS action, convert > the array to a comma delimited string, then use that variable in your > SELECT statement. > > I would also check the dimensions of the array. I don't think the automatic > conversion works if the array is more than a single column. > > > Eric > > > >----- Original Message ----- > >From: <mailto:[EMAIL PROTECTED]>James MacFarlane > >To: <mailto:[EMAIL PROTECTED]>Multiple recipients of list > witango-talk > >Sent: Friday, December 06, 2002 1:58 PM > >Subject: Witango-Talk: IS IN screws up > > > >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?!?!?! > > > >I've 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 > > ________________________________________________________________________ > 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 ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
