Try using a disconnected recordset and see if that helps. I'm not sure,
but it's worth a try.
|------------------------------+------------------------------------------|
|Eric A. Laney |"Harmony seldom makes a headline." |
|Systems Architect | |
|Verizon Security | |
|Voice: 813.987.1416 | Silas Bent, American writer (1882-1945)|
|Pager: 888.551.3718 | |
|------------------------------+------------------------------------------|
Zach Bowling
<zbowling@direct-al To: SQL <[EMAIL PROTECTED]>
liance.com> cc:
Subject: Returning a recordset
generated from a temp table in ADO
05/24/2002 04:53 PM
Please respond to
sql
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
______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
