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]
- CFStoredProc vs CFQUERY Steven Durette
- RE: CFStoredProc vs CFQUERY Shawn Grover
- Re: CFStoredProc vs CFQUERY Steven Durette
- RE: CFStoredProc vs CFQUERY Justin Greene
- RE: CFStoredProc vs CFQUERY Ray Bujarski
- RE: CFStoredProc vs CFQUERY Robert Everland
- RE: CFStoredProc vs CFQUERY Dave Watts
- RE: CFStoredProc vs CFQuery Tangorre, Michael
- Re: CFStoredProc vs CFQuery Adrocknaphobia
- RE: CFStoredProc vs CFQuery Dave Watts
- RE: CFStoredProc vs CFQuery Joe Gooch
- RE: CFStoredProc vs CFQuery Robertson-Ravo, Neil (RX)
- Verity and fb4 Mark Henderson
- Re: CFStoredProc vs CFQuery Dina Hess