, January 19, 2006 10:45 AM
To: CF-Talk
Subject: RE: cfstoredproc and cache
You can put the results into the session/application scope and manage it
yourself or call the stored procedure using cfquery tags and make use of
the cache attributes of the cfquery tag.
Mike
From: Peterson, Andrew S. [mailto
I'm sure there many ways to do this. If there is a query result that I want to
use over and over again, I will put it into a memory variable. Usually
application or session.
Bob
~|
Message:
Not on MX 6.1 natively I do not think - but you could take each resultant
query and put it into the session scope.
-Original Message-
From: Peterson, Andrew S. [mailto:[EMAIL PROTECTED]
Sent: 19 January 2006 16:26
To: CF-Talk
Subject: cfstoredproc and cache
Is there a way to cache
You can put the results into the session/application scope and manage it
yourself or call the stored procedure using cfquery tags and make use of the
cache attributes of the cfquery tag.
Mike
From: Peterson, Andrew S. [mailto:[EMAIL PROTECTED]
Is there a way to cache the results of a stored
Mike:
Have you thought about using CFQUERY and then running the EXEC command
to run the store proc?
cfquery name = sp_YourName datasource = YourDSN cachedwithin =
#CreateTimeSpan(0,0,20,0)#
EXEC YourStoredProc
/cfquery
_
From: Tangorre, Michael [mailto:[EMAIL PROTECTED]
Sent:
add
this feature to the cfprocresult tag someday :-)
-Original Message-
From: Ricky Fritzsching [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 15, 2003 10:31 AM
To: CF-Talk
Subject: RE: cfstoredproc and cache
Mike:
Have you thought about using CFQUERY and then running the EXEC command
to cfquery. Perhaps MM can
add
this feature to the cfprocresult tag someday :-)
-Original Message-
From: Ricky Fritzsching [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 15, 2003 10:31 AM
To: CF-Talk
Subject: RE: cfstoredproc and cache
Mike:
Have you thought about using CFQUERY
7 matches
Mail list logo