ack! OK, will do. Thanks!
Brian Kotek wrote: > You need to var-scope your queries, or you'll run into concurrency issues if > you store this CFC in the application scope. This is critical. You must > var-scope everything: query names, loop index variables, temp variables, > etc. > > On 9/20/07, Vince Collins <[EMAIL PROTECTED]> wrote: > >> ========== INVENTORY.CFC ============== >> <cfcomponent hint="Inventory Object"> >> <cfset variables.dsn = "" /> >> <cfset variables.inventory = "" /> >> <cffunction name="init" access="public" returnType="inventory" >> output="false" hint="I instantiate qry"> >> <cfargument name="dsn" type="string" required="yes" /> >> <!--- initiate value(s) ---> >> <cfset variables.dsn = arguments.dsn /> >> <cfset variables.inventory = "none" /> >> <cfreturn this /> >> </cffunction> >> <!--- getInventory - List inventory method ---> >> <cffunction name="getInventory" returntype="query" access="public" >> HINT="Returns all inventory as 'qryInventory', can pass optionally >> selSortBy to sort query"> >> <cfargument name="selSortBy" required="false" type="string" >> default="Class, Class_Name" /> >> <cfargument name="selInventoryID" required="false" type="numeric" >> default="0" /> >> <cfargument name="selClass_Name" required="false" type="string" >> default="" /> >> <cfargument name="selSubClass_Name" required="false" type="string" >> default="" /> >> <cfargument name="selSize" required="false" type="string" default="" >> /> >> <cfquery name="qryInventory" datasource="#variables.dsn#"> >> SELECT >> >> </cfquery> >> <cfreturn qryInventory /> >> </cffunction> >> </cfcomponent> >> >> >> > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289044 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
