错误的参数个数或无效的参数属性值: ‘MD5’


现在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”)
%>

请大家看看,哪里出错啦!!!