> 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.
To the best of my knowledge, no, you can only return multiple recordsets
using CFSTOREDPROC.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

