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]
