I want to count the number of records in a table using some ASP code. Can someone help ?
u have a recordset property rs.recordcount u can use that.
If con.cursorlocation=adUseServer ..<BR>rs.recordcount will not work.Always recordcount will return -1.<BR>To use recordcount property U have to use cursorlocation as aduseclient.
cnt=0<BR>do while not rs.eof<BR> cnt=cnt+1<BR> rs.movenext<BR>loop<BR>response.write "Total records are :" & cnt