Sql = "select username,password from forum_userdb order by id asc"
set rs = conn.execute(sql)
while not rs.eof
pwd=rs("password")
pwd= md5("password",32)
sql="insert into dv_user(userpassword) values('" & pwd & "')"
conn.execute sql
rs.movenext
wend
Rs.close
set rs = conn.execute(sql)
while not rs.eof
pwd=rs("password")
pwd= md5("password",32)
sql="insert into dv_user(userpassword) values('" & pwd & "')"
conn.execute sql
rs.movenext
wend
Rs.close
Sql = "select username,password from forum_userdb order by id asc"
set rs = conn.execute(sql)
while not rs.eof
pwd= md5(rs("password"),32)
sql="insert into dv_user(userpassword) values('" & pwd & "')"
conn.execute sql
rs.movenext
wend
Rs.close
%>
二\语法写错了while
pwd=rs("password")
pwd= md5("password",32) ----> pwd= md5(pwd,32)
......
wend
Sql = "select username,password from forum_userdb order by id asc"
set rs = conn.execute(sql)
while not rs.eof
pwd= md5(rs("password"),32)
sql="insert into dv_user(userpassword) values('" & pwd & "')"
conn.execute sql
rs.movenext
wend
Rs.close
%>