Re: run sp and return results to .asp
From: Adam Machanic (amachanic_at_hotmail._removetoemail_.com)
Date: 06/11/04
- Next message: habibi: "with nowait option in raiserror"
- Previous message: Chris DiTommaso: "run sp and return results to .asp"
- In reply to: Chris DiTommaso: "run sp and return results to .asp"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 11 Jun 2004 13:27:29 -0400
Views do not support cursors.
That said, why do you need a view to call a stored procedure?
If you're using ADO, you can use the NextRecordset method to move to the
next recordset if you return more than one.
"Chris DiTommaso" <Chris DiTommaso@discussions.microsoft.com> wrote in
message news:8C7C0A6C-1C62-48CE-A5C8-D4ECC23F0A83@microsoft.com...
> I've written a fairly complex query in sql2k, but when I attempt to paste
the query into the 'new view' generator in Enterprise Manager, I get an
error "The Query Designer does not support the DECLARE CURSOR SQL
construct." I want to be able to call the sp from the .asp page, then
return the results to an .asp page. How do I handle up to 30 recordsets
that the sp will return to the .asp?
- Next message: habibi: "with nowait option in raiserror"
- Previous message: Chris DiTommaso: "run sp and return results to .asp"
- In reply to: Chris DiTommaso: "run sp and return results to .asp"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
