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]
