ADO Recordsets via Stored Procedures in ASP

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