|
|
|
|
|
| | |
| |
Active Server Pages ASP programs help tutorial tutorials routine routines jobs listserve mailinglist bulletin board bulletin boards programming snippet snippets CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Re: ASP Photo Album & RecordSet Counting Problems |
|
From: |
Mark |
|
Date: |
2/15/2001 10:42:01 AM |
|
IP: |
208.184.60.244 |
Hi,
A quick way of doing this is to explicitly create an ADODB recordset eg
set RS = SERVER.CREATEOBJECT("ADODB.RECORDSET")
' then set the location as client side cursor
RS.CursorLocation = 3 ' adUseClient
' then open the Recordset against the Connection and SQL
RS.Open [SQL STATEMENT], [DATABASE CONNECTION OBJECT]
and you should be able to reference the number of records by using the recordcount
response.write RS.Recordcount
HTH
Mark
|
Previous Message
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
