Jeremy, if I'm understanding you, you could replace the loop with this: <cfset IDs = valuelist(CChanges.CID)>
Does that work for you? /charlie -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of <cfgroupie> Sent: Monday, May 01, 2006 9:31 PM To: cfaussie Subject: [cfaussie] Post Long weekend brain fart Hi guys, I'm just having issues with my append function. I have dead set forgotten how to do this. I have a query I want to loop over and for each time it loops over I want to append an ID. I have done this a million times...where...i don't know... code below <cfset candlist = "202,203,204,205"> <cfscript> CChanges = QueryNew("CID"); </cfscript> <cfset NewList = ''> <cfloop query="CChanges"> <cfset IDs = ListAppend(NewList,"#CChanges.CID#")> <cfoutput>#ids#</cfoutput> </cfloop> Bad week to give up coffee.. Jeremy --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~----------~----~----~----~------~----~------~--~---
