|
|
|
|
|
| | |
| |
vbscript active server pages ASP vbscript SQL database informix oracle SQL Server Perl CGI Delphi PHP source code code sample samples program CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Stored Procedures |
|
From: |
Chris |
|
Date: |
8/6/2001 7:36:33 AM |
|
IP: |
210.50.127.57 |
hi,
newbie post: ASP, SQL Server 2000, VbScript
Previously using stored queries from Access 2000
i'm trying to use a stored procedure created in SQL Server 2000, to return a recordset but i can't set the cursorType of the recordset object to allow the use of the absolute position property.
another thing i can't work out is that while moving through a loop of the recordset, SOME of the column values are being returned as null. I've checked the sql statement and it does return the correct values but not in the loop.
outside of the loop the column contain what they should.??????????
some of the stored procedures don't accept any parameters, some do. [so stored procedures or views or .....]
what would be the most effecient method of retieving the resulting recordsets. I've read about setting all the properties in the open, or execute methods.
thanks for any help,
Chris
|
Follow Up - Re: Stored Procedures - David Beal 8/13/2001 4:20:00 PM
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
