帮我看看错误,好吗?
<%
dim rs
set rs=server.createobject("adodb.recordset")
sql="select username,adddate,loginip from customer"
rs.open sql,conn,1,1
do while not rs.eof
name=rs("username")
sql3="update user set adddate=customer.adddate where username='"&name&"'"
response.write sql3
conn.execute(sql3)
rs.movenext
loop
response.write "ok"
%>