跪求ASP会员生日代码？？

假设会员表是 users
sql="select * from users where birthday = #"&date()&"#"
rs.Open sql,conn 0,1

response.write "今天是"
while not rs.eof '因为有可能有多个会员同一天生日
response.write rs("name")&"nbsp;" 'nbsp;是空格的意思
rs.movenext
wend

rs.close
set rs=nothing

会员表里面要有生日字段(短日期型)，查询就是了啊

sql="select memberid from users where birthday = #"&date()&"#"