It does indeed, and that code is safe for exactly the same reason. You should do the same thing with CFPROCRESULT as well.
cheers, barneyb On 6/23/05, Peter H <[EMAIL PROTECTED]> wrote: > Does this apply to results from a stored procs?. All my DAO's / gateways use > stored procs and I've var declared the results variables as shown below. Is > this safe? > > eg. > > <cffunction name="InsertCountry" access="public" returntype="numeric" > output="false"> > <cfargument name="Country" type="string" required="true"> > > <cfset var identity = -1 /> > > <cftry> > <cfstoredproc procedure="InsertCountry" > datasource="#variables.dsn#" > returncode="no"> > <cfprocparam value="#arguments.Country#" > type="in" > cfsqltype="cf_sql_varchar" null="no"> > <cfprocparam variable="identity" type="out" > cfsqltype="cf_sql_integer" > /> > </cfstoredproc> > > <cfcatch type="database"> > <cfrethrow /> > </cfcatch> > </cftry> > > <cfreturn identity /> > </cffunction> > > > > > > > > ----Original Message Follows---- > From: Sean Corfield <[EMAIL PROTECTED]> > Reply-To: [email protected] > To: [email protected] > Subject: Re: [CFCDev] Returning a Query from Application Scoped CFC > Date: Thu, 23 Jun 2005 09:21:24 -0700 > > On 6/23/05, Gurevich, Gerry (NIH/NIEHS) <[EMAIL PROTECTED]> wrote: > >I'm using an application scoped CFC to return a recordset. It works fine > >in > >my development environment. Do I need to worry about the site under load. > >If multiple users are using the same CFC at the same time, will they each > >have their own unique query to work with, or will they interfere with one > >another. > > As long as you have 'var'-declared all your local variables, you'll be > fine. But make sure you 'var'-declare the variable specified in the > name= attribute of your <cfquery> tags. > -- > Sean A Corfield -- http://corfield.org/ > Team Fusebox -- http://fusebox.org/ > Got Gmail? -- I have 50, yes 50, invites to give away! > > "If you're not annoying somebody, you're not really alive." > -- Margaret Atwood > > > ---------------------------------------------------------- > You are subscribed to cfcdev. To unsubscribe, send an email to > [email protected] with the words 'unsubscribe cfcdev' as the subject of the > email. > > CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting > (www.cfxhosting.com). > > CFCDev is supported by New Atlanta, makers of BlueDragon > http://www.newatlanta.com/products/bluedragon/index.cfm > > An archive of the CFCDev list is available at > www.mail-archive.com/[email protected] > > > > > ---------------------------------------------------------- > You are subscribed to cfcdev. To unsubscribe, send an email to > [email protected] with the words 'unsubscribe cfcdev' as the subject of the > email. > > CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting > (www.cfxhosting.com). > > CFCDev is supported by New Atlanta, makers of BlueDragon > http://www.newatlanta.com/products/bluedragon/index.cfm > > An archive of the CFCDev list is available at > www.mail-archive.com/[email protected] > > > -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 50 invites. ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [email protected] with the words 'unsubscribe cfcdev' as the subject of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com). CFCDev is supported by New Atlanta, makers of BlueDragon http://www.newatlanta.com/products/bluedragon/index.cfm An archive of the CFCDev list is available at www.mail-archive.com/[email protected]
