|
|
|
|
|
| | |
| |
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: 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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
