If you're only returning one result set, you can call the stored proc with
the CFQUERY tag, which will then allow you to cache the results as well. I
have also found that using CFQUERY rather than CFSTOREDPROC gives me much
more meaningful error messages. I got really tired of seeing "Unknown Data
Access Error".
Bob
-----Original Message-----
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: January 11, 2001 10:54 AM
To: CF-Talk
Subject: RE: Can you cache CFSoredProc?
> I'm using CFStoredProc for Access queries. Is there
> any way to cache them?
You can't use CACHEDWITHIN/CACHEDAFTER query caching with the CFSTOREDPROC
tag, but you can stick the recordset into a persistent memory variable
(Session, Application, Server).
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
