I think the best part of CFSTOREDPROC is the ability to return multiple
recordsets.  You could run a stored procedure that runs 4 queries and
keep track of them separately.

Joe

  _____  

From: Duane Boudreau [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 29, 2004 2:59 PM
To: CF-Talk
Subject: CFStoredProc vs CFQuery

Are there any benefits to calling stored procedures using CFStoredProc
vs.
CFQuery? All the stored procs return a single record set.

The limitation I am running in to is how to cache the results of a query
that is created calling CFStoredProc.

TIA,
Duane

  _____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to