ASP怎么实现判断数据库是否有数据

[Larsson111]

有张表asset, 表里有个字段name, 我想判断在数据库里有name=zhangsan数据时，返回1， 无此数据，返回2

[pig510520]

if rs("name")="zhangsan" then
response.write 1
else
response.write 2
end if

[lzp4881]

if exists(select * from asset where name='zhangsan')
return 1
else
return 2

[hookee]

<%
sConn = "....."
Set conn = CreateObject("ADODB.Connection")
conn.Open sConn

sql = "SELECT COUNT(*) FROM asset WHERE [name]='zhangsan'"
Set rs = CreateObject("ADODB.RecordSet")
rs.CursorLocation = 3
rs.Open sql, conn, 1, 1
c = rs(0).Value
rs.Close
Set rs = Nothing
conn.Close
Set conn = Nothing

If c = 0 Then
   Response.Write 2
Else
   Response.Write 1
End If
%>

[hfwtyyh]

 <%Set Rs  = Server.CreateObject("adodb.RecordSet")
	Sql =  "Select * from [user] Where username='zhangsan'"
	Rs.Open Sql,Conn,1,1
	If Not Rs.Eof Then
		Response.Write("此用户名称已经存在,请选择其它用户名称") 
	Else
		Response.Write("您可以注册此用户名称,确定下一步完善资料") 
	End if
	RS.Close%>

[Larsson111]

谢谢 各位高手