I know you can call
sps with cfquery and use named parameters, like so
<cfquery
name="qResult"...>
EXEC
spMyStoredProcedure @myParam = 'test'
</cfquery>
But, the million
dollar question is: how do you retrieve multiple result sets with this syntax?
In this case qResult only returns one result set..
I could of course
return one big xml result set which contains all three but that's a pain, I
really hate cfstoredproc...
Anyone?
Taco
Fleur
Tell me and I will forget
Show me and I will remember
Teach me and I will learn
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
