sql="select * from table where name like '%"&查找的名字&"%'"set rs=conn.execute(sql)if not(rs.eof and rs.bof) thendo while not

sql="select * from table where name like '%"&查找的名字&"%'"

set rs=conn.execute(sql)

if not(rs.eof and rs.bof) then

do while not rs.eof

Userid=rs("ID")

sql1="delect from table where id="&Userid

conn.execute(sql1)

rs.movenext

loop

end if

上一篇：asp 字段判断为空 下一篇：asp判断今天是星期几