lngcatalogid=clng(GetSess("Productid"))
sql1="update products set cname='" & strcname & "',mfg='" & strmfg & "',categoryid=" & strcategoryid & ",supplierid=" & strbrandid
sql1=sql1 & ",hometaste=" & strhometaste & ",cdescription='" & memcdescription & "',ingredients='" & stringredients & "',ccode='" & strccode & "',upc='" & strupc
sql1=sql1 & "',extendedimage='" & strextendedimage & "',cprice=" & curcprice & ",weight='" & strweight & "',piecespercase=" & strpiecespercase
sql1=sql1 & ",case_weight=" & strcase_weight & ",case_size=" & strcase_size & ",package='" & strpackage & "',hide=" & strhide & ",groupid=" & strgroupid
sql1=sql1 & ",factory_place='" & strfactory_place & "' where catalogid=" & lngcatalogid
conn_tkt.Execute(sql1)
这段代码错在哪了？
错误提示
Microsoft OLE DB provider for sql server error '80040e14'
Line 1:Incorrect syntax near','.
前几天好用的程序突然间这样了
谢谢