如何取得记录条数

[JensiaTsang]

'打开数据库读出用户名
set conn=opendb("oabusy","conn","accessdsn")
set rs=server.createobject("adodb.recordset")
sql="select name from userinf where username=" & sqlstr(request("username"))
rs.open sql,conn,1
=============
name=rs("name")
//这里要判断一下，如果返回有记录就赋值，否则就赋空
=============

类似于这样：
if rs.recordcount= then

else

以上是DELPHI语法。麻烦换成ASP的

[wolf004]

COUNT

[wolf004]

sql="select COUNT(*|字段名) as 别名 from 数据表 where 条件表达式"

[pp4u]

while not rs.eof

[diya]

rs.open sql,conn,3,1
if rs.RecordCount=0 then
.....
else
.....
end if

[511214]

set conn=server.createobject("adodb.connection")
conn.open "driver={sql server};server=servername;database=databasename;uid=username;pwd=passward;"
sql="select name from userinf where username=" & sqlstr(request("username"))
set rs=conn.execute(sql)
if rs.bof and rs.eof then
name=""
else
name=rs("name")
end if

[119311canoe]

set conn=server.createobject("adodb.connection")
conn.open "driver={sql server};server=servername;database=databasename;uid=username;pwd=passward;"
sql="select name from userinf where username=" & sqlstr(request("username"))
set rs=conn.execute(sql)
if not rs.eof then
name=rs("name")
else
response.write"没有记录"
rs.movenext
end if
wend

[Bullforg]

response.write "总计"&rs.recordcount&"条记录"

[JensiaTsang]

分太少，所以分得少