lede ssh登录不上:asp修改数据问题

来源:百度文库 编辑:高校问答 时间:2024/05/01 13:48:06
这段代码是这样的,不知道是那里出了问题
set rs=server.createobject("adodb.recordset")
mysql = "select * from admin_member where id = " & id
rs.open mysql ,conn,3,2
if rs.eof or rs.bof then
rs.close
set rs=nothing
msg "你要修改的客户不存在,无法更新。","Back","None"
response.end
end if
' pid=rs.fields("pid")
rs.fields("vType")=vType
rs.fields("vNumber")=vNumber
rs.fields("vNo")=vNo
rs.fields("vCname")=vCname
rs.fields("vCaddress")=vCaddress
rs.fields("vCmaster")=vCmaster
rs.fields("vCphone")=vCphone
rs.fields("vName")=vName
rs.fields("vAge")=vAge
rs.fields("vSex")=vSex
rs.fields("vID")=vID
rs.fields("vPhone")=vPhone
rs.fields("vAddress")=vAddress
rs.fields("vNumber")=vNumber
rs.fields("vEmail")=vEmail
rs.update
rs.close
set rs=nothing
msg "修改成功。","GoUrl","../manage/admin_member_list.asp"
response.end

if rs.eof or rs.bof then 应该修改为if rs.eof then 后面的end if 应该修改为else 在rs.update 的后面增加end if语句。

错误提示呢