Yes, but you'll have to use CFQUERY to call your SP. So that limits you to
a single result set and you cannot use CFQUERYPARAM. Unless your
recordset(s) are really large, you're better off using CFSTOREDPROC to call
the SP. I guess in a worst case scenario, you could store the query in a
application or session scoped variable and call it from there...
HTH,
Jeff Garza
Lead Developer/Webmaster
Spectrum Astro, Inc.
480.892.8200
[EMAIL PROTECTED]
http://www.spectrumastro.com
-----Original Message-----
From: Don Vawter [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 20, 2001 9:52 PM
To: CF-Talk
Subject: Cache sp result set
Is there any way to cache the result set returned by a stored proced in SQL
Server 2000, CF 5
TIA
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
