November 27, 2005 at 9:43 am
I am trying to base an ASP (not .NET) page off of a stored procedure (sp). The sp creates a temporary (temp) table, then links that temp table in a following query (but in the same sp) that gives me my final recordset. This keeps me from having to use a subquery. The sp runs fine in QA, but while I'm building the page in Dreamweaver I get an error that says, "recordset must return data". It's as if Dreamweaver cannot see the temp table to base the page off of. What gives?
November 30, 2005 at 8:00 am
This was removed by the editor as SPAM
November 30, 2005 at 8:25 am
Are you issuing a SELECT statement in the stored procedure against the temporary table? Or are you just creating the temporary table and then having the ASP code reference it?
K. Brian Kelley
@kbriankelley
November 30, 2005 at 8:29 am
I am issuing a SELECT statement against the temp table.
November 30, 2005 at 8:33 am
What happens if you just write a dummy ASP page using a different tool, even Notepad, just to confirm you're getting data back? Say open the recordset by calling the stored procedure and spit the contents into the table. If that works, it sounds like a bug with Dreamweaver.
K. Brian Kelley
@kbriankelley
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply