> > Two follow up questions. You can't directly use the var key > word in the <cfquery> tag; <cfquery name="var joe"...>.
Correct. You also can't do <cfset var ...> after any line of real code. So, your first N lines of a method will be cfargument tags, then cfset var tags, then 'real' code. So, that's why you saw me do: <cfset var q = ""> <cfquery name="q" .....> > Also, when exactly does this data get garbage collected? Um, I'm assuming when the method is done. > Since it is in a method, does a query get created and > destroyed every time that method is used? I does it persist > for the life of the entire component? > The query does NOT persist because I used the var scope. However, imagine a case where you query to get the states in the US. This will not change anytime soon. Your code could look like so (pseudo-code): (above, in the constructor area) <cfset local = structNew()> <cffunction name="getStates" ....> <cfset var q = ""> <cfif not structKeyExists(local,"states")> run a query and get the states in query named q <cfset local.q = duplicate(q)> </cfif> <cfreturn local.q> </cffunction> In this example, the query persists as long as the CFC persists. ======================================================================== === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email : [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus "My ally is the Force, and a powerful ally it is." - Yoda ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4