一个表单输入框什么都不填,保存到money老提示“第 1 行: ',' 附近有语法错误。”有错误,填上数字就不报错误,
pc_id = trim(request.Form("pc_id"))
backtime = trim(request.Form("backtime"))
backsum = trim(request.Form("backsum"))
dutyname = trim(request.Form("dutyname"))sql="update TG_sincere set backtime='"&backtime&"',backsum="&backsum&",dutyname='"&dutyname&"' where pc_id='"&pc_id&"'"其中backsum是那个money类型的字段
pc_id = trim(request.Form("pc_id"))
backtime = trim(request.Form("backtime"))
backsum = trim(request.Form("backsum"))
dutyname = trim(request.Form("dutyname"))sql="update TG_sincere set backtime='"&backtime&"',backsum="&backsum&",dutyname='"&dutyname&"' where pc_id='"&pc_id&"'"其中backsum是那个money类型的字段
最好打印出SQL语句分析分析