UC知道update set无法向数据库添加数据
来源：百度知道 编辑：UC知道 时间：2024/05/25 18:51:20
我向一个库里添加数据
strsql="update JOB_school_stu set "
strsql=strsql & "JOB_StudType='"&request("studtype")&"',"
strsql=strsql & "JOB_StudInfo='"&request("studinfo")&"',"
strsql=strsql & "JOB_StudNum='"&request("studnum")&"',"
strsql=strsql & "JOB_MaleNum='"&request("MaleNum")&"',"
strsql=strsql & "JOB_FemaleNum='"&request("FemaleNum")&"',"
strsql=strsql & "JOB_DegreeID='"&request("DegreeID")&"',"
strsql=strsql & "JOB_ForginID='"&request("ForginID")&"',"
strsql=strsql & "JOB_AvailDate='"&request("AvailDate")&"',"
strsql=strsql & "JOB_Status='"&request("Status")&"',"
strsql=
strsql="update JOB_school_stu set "
strsql=strsql & "JOB_StudType='"&request("studtype")&"',"
strsql=strsql & "JOB_StudInfo='"&request("studinfo")&"',"
strsql=strsql & "JOB_StudNum='"&request("studnum")&"',"
strsql=strsql & "JOB_MaleNum='"&request("MaleNum")&"',"
strsql=strsql & "JOB_FemaleNum='"&request("FemaleNum")&"',"
strsql=strsql & "JOB_DegreeID='"&request("DegreeID")&"',"
strsql=strsql & "JOB_ForginID='"&request("ForginID")&"',"
strsql=strsql & "JOB_AvailDate='"&request("AvailDate")&"',"
strsql=strsql & "JOB_Status='"&request("Status")&"',"
strsql=
strsql=strsql & "where JOB_user="&session("schooluser")&" and JOB_id="&request("JOB_id")&""
这句中也要加上单引号，否则如果session("schooluser")或者request("JOB_id")是空的话都会引起语句执行失败。
strsql=strsql & "where JOB_user='"&session("schooluser")&"' and JOB_id='"&request("JOB_id")&"'"
当然，最严谨的做法就是在执行语句前，检查request的数据是不是都是有效的。