I am trying to run a stored procedure which returns a recordset to ado, here is basically what is happening
create a temp table insert records into temp table Create a second temp table using the first temp table insert a summary into the second temp table finally, select all of the records from the second temp table as our final recordset the problem that I am getting is that it says my recordset is closed whenever I run it from ADO On another note, I can run and plain select statement from a stored proc through ADO and it works fine, but any with temp tables fail and say my recordset is closed. Zach Bowling Sr. Manager of Customer Analytics Work: 480.902.5908 Mobile: 602.391.5454 Email: [EMAIL PROTECTED] http://www.direct-alliance.com ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
