|
|
|
|
|
| | |
| |
Active Server Pages asp source code database MS SQL MS Access .mdb adovbs.inc cookies calendar codes sql commands scripts asp programming tutorials iis web server components 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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
