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]
