How are you calling the proc? If you use cfstoredproc
Then use this at the bottom: <cfprocresult name="resultset_name_1" resultset="1"> <cfprocresult name=" resultset_name_1" resultset="2"> ~Brad -----Original Message----- From: Tim Heald [mailto:[EMAIL PROTECTED] Sent: Monday, January 09, 2006 11:07 AM To: CF-Talk Subject: Stored Proc/CF help!! Ok, Sorry for the OT-ish question, but I was gone for so long that I am having some crazy problems writing this SQL Server Stored proc. I have something like this: Create procedure get_stuff(@status int) As Select @status = status >From table Where things = 1 If @status = 1 begin select cdata, cdate from table where cdata = 1 end End if How would I return the second query to CF? I know that's not the greatest example, and it prolly won't even run, but it's close. I can answer questions if need be. TIA Tim Heald [EMAIL PROTECTED] ColdFusion Developer Signal Solutions, Inc Work : 202-224-1224 Cell : 703-765-0618 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:228873 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
