請大家指點下。
sql= "update [Mat_M] set Style_S_ID= ' "&ID& " ',Mat_Nm= ' "&Nm& " ',Mat_Brand= ' "&Br& " ',Mat_Style= ' "&St& " ',Mat_Desc= ' "&De& " ' where Mat_ID like ' "&ID1& " '
提示錯誤
無法判定字串常數的結尾
/Mat/web.Update2WP.asp, line 20, column 142
sql= "update [Mat_M] set Style_S_ID= ' "&ID& " ',Mat_Nm= ' "&Nm& " ',Mat_Brand= ' "&Br& " ',Mat_Style= ' "&St& " ',Mat_Desc= ' "&De& " ' where Mat_ID like ' "&ID& " '
麻煩大家給小第指點哈了。。
------解决方案--------------------少了个 "
sql= "update [Mat_M] set Style_S_ID= ' " & ID & " ',Mat_Nm= ' " & Nm & " ',Mat_Brand= ' " & Br & " ',Mat_Style= ' " & St & " ',Mat_Desc= ' " & De & " ' where Mat_ID like ' " & ID1 & " ' "