RE: cfstoredproc and cache

2006-01-20 Thread Peterson, Andrew S.
, 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

Re: cfstoredproc and cache

2006-01-19 Thread Robert Everland III
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:

RE: cfstoredproc and cache

2006-01-19 Thread Robertson-Ravo, Neil (RX)
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

RE: cfstoredproc and cache

2006-01-19 Thread Michael T. Tangorre
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

RE: cfstoredproc and cache

2003-10-15 Thread Ricky Fritzsching
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:

RE: cfstoredproc and cache

2003-10-15 Thread Tangorre, Michael
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

RE: cfstoredproc and cache

2003-10-15 Thread Ricky Fritzsching
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