zach, you have piqued my curiosity. if i may ask, what exactly are you trying to accomplish within your stored procedure? by temp table, do you mean a derived table that's created on the fly? what information are you trying to summarize from table one?
i think i may be of help if you wouldn't mind clarifying your problem a bit more. ~ dina ----- Original Message ----- From: "Zach Bowling" <[EMAIL PROTECTED]> To: "SQL" <[EMAIL PROTECTED]> Sent: Friday, May 24, 2002 3:53 PM Subject: Returning a recordset generated from a temp table in ADO > 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 > > ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
