|
|
|
|
|
| | |
| |
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: Problem with RecordCount |
|
From: |
Raymond Skorstad |
|
Date: |
8/26/1999 7:23:04 AM |
|
IP: |
139.109.4.129 |
If the recordset doesnt support adApproxPosition or adBookmark, you cant use recordcount, even if you use adStatic.
To test if your recordset, do:
If rst.Supports(adBookmark) Or rstStat.Supports(adApproxPosition) Then
response.write "Recordset will work!"
else
response.write "Recordset doesnt work!"
End If
In order to tell if you have records in the recordset, simply test:
if rs.Eof then
recordset empty
else
recordset not empty
end if
if you need to actually count the records, youd need to either run through the recordset and count:
dim nCount
nCount=0
do while not rs.Eof
ncount=nCount+1
rs.MoveNext
loop
nCount=nCount-1
response.write nCount&" records read."
or you could create a stored procedure on the server (if SQL) to return the count, or run:
strSql="SELECT count(*) FROM sak"
rs.Open strSql, con
Response.write "Recordcount= "&rs(0)
The last one is definitely the best and quickest on!
Check www.delphi.com/myasp for tips |
Previous Message
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
