It's called cfprocresult and it allows you to return multiple recordsets.
-----Original Message-----
From: Tangorre, Michael [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 29, 2004 12:33 PM
To: CF-Talk
Subject: RE: The search is killing the server. Please help!
> The advantages of doing this instead of using the
> CFSTOREDPROC tag are that you can cache recordsets using
> CACHEDWITHIN/CACHEDAFTER, and that you can write it a little
> more easily in some cases.
Is there anyway to reference more than one recordset? We have a lot of
stored procs that return 2 or 3 so we find ourselves using cfstoredproc in
those instances and cfquery with EXEC PRON_NAME in other instances.. Mainly
select queries where we want to cache the results.
Mik
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
