dpeterson
Posts: 13
|
| Posted: 06/14/2007, 8:49 AM |
|
I was wondering if anyone had any insight into a problem we've recently encountered.
We have a page that calls a stored procedure to populate 3 grids. This stored procedure makes a temporary table for only one of them, and then returns a couple of rows (for the others it's just a straight SELECT statement). Anyway, this webpage works fine in the old Code Charge 2.2.
However, when we converted to 3.1, the web page stops working. We made no other alterations. It gives:
ADODB.Recordset error '800a0e78'
Operation is not allowed when the object is closed.
Some more Information:
1) This error only occurs for the grid that uses the temporary tables. What this stored procedure does is return one record from three temporary tables, all unioned together
2) The stored procedure still runs (and you can tell) because it takes a dozen seconds or so for the webpage to load
3) Running the stored procedure in SQL still works (like I said it still works for the old version of CodeCharge
4) The line where the above code quits out on is the following (from Classes.asp):
Property Get EOF()
EOF = Recordset.EOF
End Property
5) I've tried renaming the file, I've tried deleting all the common code and republishing. Even when I tried setting up the grid from scratch and running with this one stored procedure, it refuses to wrok. I have also tried deleting out all the controls that would load any fields from the stored procedure.
So I guess my main question is this - Does the new CodeCharge 3.1 have any known issues with stored procedures that either use a union select statement, stored procedures that use temporary tables, or populating grids by stored procedures in general? Thanks for you help!
|
 |
 |
Wkempees
|
| Posted: 06/14/2007, 9:11 AM |
|
Would suggest addressing this straight to support
http://support.yessoftware.com
|
|
|
|
|
