建站常识

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