> If b is only a number then how come the above line of code works perfectly.
b isn't a number, I was purposely trying to give you the wrong answer because I'm evil. Not cos I'm thick, oh no, that wasn't why. seeing as you're using UUIDs, just qualify them first: WHERE journoid IN (#listqualify(attributes.journoid, "'")#) now you don't need to loop. > -----Original Message----- > From: Rich Wild [mailto:[EMAIL PROTECTED]] > Sent: 27 January 2003 16:37 > To: '[EMAIL PROTECTED]' > Subject: RE: [ cf-dev ] Spot the problem - IN() > > > I can redeem myself (god how embarrasing - must get more > sleep) by saying > that my last bit still stands - don't understand why you're > using all that > loop gubbins when you could just use: > > WHERE journoid IN (#attributes.journoid#) > > Rich "Spastic of the Day" Wild > > > -----Original Message----- > > From: Rich Wild [mailto:[EMAIL PROTECTED]] > > Sent: 27 January 2003 16:31 > > To: '[EMAIL PROTECTED]' > > Subject: RE: [ cf-dev ] Spot the problem - IN() > > > > > > bollocks, ignore me. I'm tired and wrong. > > > > > -----Original Message----- > > > From: Rich Wild [mailto:[EMAIL PROTECTED]] > > > Sent: 27 January 2003 16:27 > > > To: '[EMAIL PROTECTED]' > > > Subject: RE: [ cf-dev ] Spot the problem - IN() > > > > > > > > > this bit is the wrong bit: > > > > > > <cfif ListLast(attributes.journoid) NEQ d>, </cfif> > > > > > > listlast returns the value of the final index of a list. > > > > > > so listlast('1,2,3,4') returns '4' > > > > > > when looping over a list, the index variable (here you're > > > using 'd') gives > > > you the position of that index. > > > > > > ie <cfloop list="apple,banana,cat,pomegranate,squirrel > > > fishing,wombats" > > > index="d"><cfoutput>#d#,</cfoutput></cfloop> > > > > > > won't give you the actual values 'apple' etc, it'll give you > > > '1,2,3' etc > > > > > > perhaps you want this (using listlen()): > > > > > > <cfif Listlen(attributes.journoid) NEQ d>, </cfif> > > > > > > if your lists contain numeric values only (which I suspect > > > judging by their > > > names) then why don't you just do this: > > > > > > WHERE journoid IN (#attributes.journoid#) > > > > > > ? > > > > > > > > > > -----Original Message----- > > > > From: [EMAIL PROTECTED] > > > > [mailto:[EMAIL PROTECTED]] > > > > Sent: 27 January 2003 16:22 > > > > To: [EMAIL PROTECTED] > > > > Subject: Re: [ cf-dev ] Spot the problem - IN() > > > > > > > > > > > > > > > > is there some sort of issue with your list delimiters? Maybe > > > > specify what > > > > these are in your ListLast function. > > > > > > > > > > > > Duncan Cumming > > > > IT Manager > > > > > > > > http://www.alienationdesign.co.uk > > > > mailto:[EMAIL PROTECTED] > > > > Tel: 0141 575 9700 > > > > Fax: 0141 575 9600 > > > > > > > > Creative solutions in a technical world > > > > > > > > > > > > > > ---------------------------------------------------------------------- > > > > Get your domain names online from: > > > > http://www.alienationdomains.co.uk > > > > Reseller options available! > > > > > > > > > > ---------------------------------------------------------------------- > > > > > > > > > > ---------------------------------------------------------------------- > > > > > > > > > > > > > > > > > > > > > > > > Dave Phipps > > > > > > > > <dave@phipps- To: ColdFusion > > > > User group <[EMAIL PROTECTED]> > > > > cf.co.uk> cc: > > > > > > > > Subject: [ > > > > cf-dev ] Spot the problem - IN() > > > > 01/27/03 > > > > > > > > 04:12 PM > > > > > > > > Please > > > > > > > > respond to > > > > > > > > dev > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Hi, > > > > > > > > I am running into a problem with a query that is looking at a > > > > list to get > > > > the records for items in the list. I have three queries all > > > > running very > > > > similar code and the last query is not putting the comma in > > > > between the > > > > list items and therefore is returning no records. > > > > > > > > The line of code is: > > > > > > > > WHERE journoid IN (<cfloop index="d" > > > > list="#attributes.journoid#">'#d#'<cfif > > > > ListLast(attributes.journoid) NEQ > > > > d>, </cfif></cfloop>) > > > > > > > > In the debug I see the two journoid values listed but > > > without a comma > > > > separating them. > > > > > > > > I have another query which uses this code: > > > > WHERE journoNatOpt.natOptid IN(<cfloop index="c" > > > > list="#valuelist(storyNatOpt.natOptid)#">'#c#'<cfif > > > > ListLast(valuelist(storyNatOpt.natOptid)) NEQ c>, > > </cfif></cfloop>) > > > > > > > > As you can see there is not a great deal of difference > > > between the two > > > > lines except that the first one does not work. > > > > > > > > Can anyone spot what I have missed? > > > > > > > > Cheers > > > > > > > > Dave > > > > > > > > > > > > -- > > > > ** Archive: > > http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > For human help, e-mail: [EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > > > > -- > > > ** Archive: > http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > For human help, e-mail: [EMAIL PROTECTED] > > > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
