日期:2014-05-17  浏览次数:20921 次

很郁闷的sql语句,帮忙看看报错原因
语句如下:

conn.Execute   = "update   hb_info   set   hb_type= "&request.Form( "hb_type ")& ",hb_right= ' "&hbd_right& " ',hb_stat= ' "&hbd_stat& " '   where   id= "&request.Form( "hbid ")& " "

报错如下:

Microsoft   VBScript   编译器错误   错误   '800a0401 '  

语句未结束  

info.asp,行   675  

conn.Execute   = "update   hb_info   set   hb_type= "&request.Form( "hb_type ")& ",hb_right=( "&hbd_right& "),hb_stat=( "&hbd_stat& ")   where   id= "&request.Form( "hbid ")& " "
---------------------------------------------^


------解决方案--------------------
&和h不能写在一起,当中加个空格,写在一起表示16进制数,
conn.Execute "update hb_info set hb_type= " & request.Form( "hb_type ") & ",hb_right= ' " & hbd_right & " ',hb_stat= ' " & hbd_stat & " ' where id= " & request.Form( "hbid ")

------解决方案--------------------
conn.Execute "update hb_info set hb_type= " & request.Form( "hb_type ") & ",hb_right= " & hbd_right & ",hb_stat= " & hbd_stat & " where id= " & request.Form( "hbid ")