Also, just to touch on that... If you do a query that doesn't return a result set (ie. An update, insert) then the variable is deleted from the LOCAL function scope. If you then run another query IN THE SAME FUNCTION with the same name, it will make this query result set globallay available to the CFC since it no longer has a var'd variable.
I have not tested this, but I remember reading a blog post about it. -b ...................... Ben Nadel Certified Advanced ColdFusion Developer www.bennadel.com -----Original Message----- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 17, 2006 2:14 PM To: CF-Talk Subject: RE: CFC oddness True. Unless you var the query name, it will be in the variables scope, which means it is available to the entire cfc. So, all methods can access (and return) the variable. Of course, this assumes that method 1 has been called BEFORE method 2 to create the variable. ~Brad -----Original Message----- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 17, 2006 1:03 PM To: CF-Talk Subject: Re: CFC oddness i believe this is why folks suggest var scoping your variables in your CFC methods :) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257070 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4