Yes, each time the function recurses into itself you want it to start over with a new set of variables specific to that particular run. Unless otherwise specified, your variables such as the query are placed in the "variables" scope which is global. That means as soon as your function called itself, it would overwrite the variables from the previous iteration, and when it returned back to the original iteration, the variables were not as they had been left.
Think of recursion as a stack, where every time you recurse back into your self, you place the previous function call "on hold" on top of a stack to come back to later. There are in fact times when a variable should not be varred, like if you wanted to keep some global counter of how many times your function ran or something. In general though most variables (especially result sets and loop indexes) should be local. As a broad rule, all variables should be varred inside of a function or a method of a CFC if you want them to be local to that method only. If for nothing else then to make sure you don't inadvertently overwrite another variable on your page with the same name. ~Brad -----Original Message----- From: Richard White [mailto:[EMAIL PROTECTED] Sent: Monday, June 02, 2008 4:29 PM To: CF-Talk Subject: Re: recursive functions and cfqueries spot on, thanks brad, works perfectly, just so i understand, does this make a difference because then it is creating a new variable each iteration, and if you don't set it then just puts it into the existing variable? i don't use many vars in my code, is that bad practise? thanks again for your help ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306643 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
