id=session("id"
huidanren_temp=request.form("HuiDanRenName"
hdtime=now()
pingxingxian_temp=request.form("pingxingxian"
Modem_temp=request.form("modem"
wangka_temp=request.form("wangka"
conn.Execute "update ljZhuangYiJi set hdtime='"&hdtime&"',PingXingXian='"&pingxingxian_temp&"',Modem='"&Modem_temp&"',wangka='"&wangka_temp&"',huidanren='"&huidanren_temp&"',DianLanGuiGe='"&DianLanGuiGe&"',DianLanChangDu='"&DianLanChangDu&"' Where id='"&id&"'"
上面的sql语句中去掉hdtime='"&hdtime&"'就运行正常,加在上面就提示语句未结束,
单独执行conn.Execute "update ljZhuangYiJi set hdtime='"&hdtime&"' Where id='"&id&"'"也一样出错,
还有就是conn.Execute "update ljZhuangYiJi set hdtime='"&now()&"' Where id='"&id&"'"就没问题,
为什么加了个参数就不行了呢,更奇怪的就是程序原来都运行着没问题的,昨天多加了更新的项目后才开始出错的!