Why do you need to lock it? Shawn Regan
-----Original Message----- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 26, 2002 6:24 AM To: CF-Talk Subject: RE: What is the best variable scope? At 03:18 AM 6/26/2002 -0400, you wrote: > > However, many people use the application scope for things that I don't > > consider good ideas (such as a datasource varaible). > >Can you elaborate? In the example I specified, a datasource variable. First you have to put it into an application variable, so code similar to this goes into the Application.cfm : <cflock> <cfif isDefined("Application.dsn")> <cfset application.dsn = "mydatasource"> </cfif> </cflock> Now you have to lock all your query statements every time you reference the variable: <cflock> <cfquery datasource="#application.dsn#"> </cfquery> </cflock> In this case, you have added additional locking code, which takes additional processing time, with no real added benefit for storing the datasource information in an application variable. -- Jeffry Houser | mailto:[EMAIL PROTECTED] Need a Web Developer? Contact me! AIM: Reboog711 | Fax / Phone: 1-203-379-0773 -- My CFMX Book: <http://www.amazon.com/exec/obidos/ASIN/0072225564/instantcoldfu-20> My Books: http://www.instantcoldfusion.com My Band: http://www.farcryfly.com ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists