现在SQL2000中有两个字段,分别是password,md5password,想用浏览器运行时,把password下的明文密码转化为MD5加密后的32位暗文密码,
我用ASP写的如下程序::运行时提示以下错误:错误的参数个数或无效的参数属性值: ‘MD5’
程序::
<%
dim sql,rs 
sql=”select * from testmd5″ 
set rs=server.CreateObject(“adodb.recordset”) 
rs.open sql,conn,1,3 
rs.movefirst 
while not rs.eof
rs(“md5password”)=MD5(trim(rs(“password”)),32)
rs.update 
rs.movenext 
wend 
rs.close 
set rs=nothing
response.write(“生成完毕,good luck”) 
%>
请大家看看,哪里出错啦!!!