[cfaussie] Re: Post Long weekend brain fart
Tis cool Guys, I was a dead set tard that day. It was a web service so I have it sending back the entire query. But yes adam I see your code and raise you a uh Huh...that would work. thanks again!! Jeremy --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Post Long weekend brain fart
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: cfaussie@googlegroups.com [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 cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Post Long weekend brain fart
Hi Jeremy,I guess the one thing I am missing here is how you are changing the list into a query?why not just loop over the list?On 5/2/06, cfgroupie [EMAIL PROTECTED] wrote: Hi guys,I'm just having issues with my append function. I have dead setforgotten how to do this. I have a query I want to loop over and foreach time it loops over I want to append an ID. I have done this a million times...where...i don't know... code belowcfset candlist = 202,203,204,205cfscriptCChanges = QueryNew(CID);/cfscriptcfset NewList = '' cfloop query=CChangescfset IDs = ListAppend(NewList,#CChanges.CID#)cfoutput#ids#/cfoutput/cfloopBad week to give up coffee.. Jeremy-- Lucashttp://www.thebitbucket.net --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Post Long weekend brain fart
No I'm just cutting down the code so that you can see what I'm getting at. Its coming from a query, I'm just using querysetcell to illustrate that. Obviously not very well.hehehe. I'm looping over a query nonetheless, each time I loop over I want to append the CID. I swear I'm gonna kick myself when I'm done with this. J. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Post Long weekend brain fart
you might want to be doning thiscfset NewList= ListAppend(NewList,#CChanges.CID#)listAppend returns a listOn 5/2/06, cfgroupie [EMAIL PROTECTED] wrote: No I'm just cutting down the code so that you can see what I'm gettingat. Its coming from a query, I'm just using querysetcell to illustratethat. Obviously not very well.hehehe. I'm looping over a querynonetheless, each time I loop over I want to append the CID. I swear I'm gonna kick myself when I'm done with this.J. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Post Long weekend brain fart
Ahh ok, got ya - ok so the query that you are looping over doesn't have any records in it...if it did, the loop over CChanges would contain the ids you need.L.On 5/2/06, cfgroupie [EMAIL PROTECTED] wrote: No I'm just cutting down the code so that you can see what I'm gettingat. Its coming from a query, I'm just using querysetcell to illustratethat. Obviously not very well.hehehe. I'm looping over a querynonetheless, each time I loop over I want to append the CID. I swear I'm gonna kick myself when I'm done with this.J.-- Lucashttp://www.thebitbucket.net --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---