Re: ADO Recordsets via Stored Procedures in ASP

Tech-Archive recommends: Fix windows errors by optimizing your registry

Michael C wrote:
I have a SP that contains a 'CURSOR' for looping through records and
basically creating a custom 'PIVOT' style column and attaches it to a
'Select' statement...works great in SQL Server.

When I call the SP from my ASP page (parameterless) I get all the
columns back properly, but all the rows are blank. If I remove the
'CURSOR' then it works great (but of course the column I am pivoting
is now blank).

Any idea why this is, or any suggestions for this ASP newbiew? TIA.

Michael
My initial thought was that you needed a SET NOCOUNT ON statement, but your
symptoms don't really indicate that solution.

I think we need more details. Keep in mind that only a SELECT statement can
return a resultset in the correct form to populate a recordset.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.

Relevant Pages

  • Re: Writing a GUID to a SQL table
    ... I strongly suspect that it is SQL Server, ... >> Please reply to the newsgroup. ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)
  • Re: large varchar columns in SQL server
    ... I had users' data stored in a SQL server database that was ... fields to a web page; the original SQL server ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)
  • Re: HTTP 401.2 problems when writing data to SQL server
    ... the Windows credentials are not being passed for some reason. ... sites have been granted permissions in the sql server ... ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)
  • Re: Display ADO Recordset in Access
    ... I'm not looking for a lecture or debate. ... Currently Using SQL Server 2000, ... I really don't need responses from people who can't answer my ... This email account is my spam trap so I ...
    (microsoft.public.data.ado)
  • Re: Comparing strings. For some reason, Im missing something.
    ... > database (MS SQL Server) was adding an extra space at the end of any ... It's probably because you are using a char datatype instead of varchar. ... This email account is my spam trap so I don't check it very often. ...
    (microsoft.public.scripting.vbscript)