|
|
|
|
|
| | |
| |
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: |
Re: Recordset properties (PageCount, RecordCount) returns -1 |
|
From: |
jazz |
|
Date: |
9/26/2000 9:30:15 AM |
|
IP: |
213.38.91.130 |
To return a record set with a record count you need to use adOpenKeyset
---- CursorTypeEnum Values ----
Const adOpenForwardOnly = 0
Const adOpenKeyset = 1
Const adOpenDynamic = 2
Const adOpenStatic = 3
Set the cursorType property for the recordset
set rs = createobject("adodb.recordset")
rs.cursortype=adOpenKeyset
sql = "select fields from table where [...]"
rs.open sql, dbconnection
|
Previous Message
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
