[ASP ] 有關Update
SQLstr = "UPDATE Drugs SET CName='"&mCName&"',
WHERE LicenseNo='"&MLicenseNo&"' "
(一)
Application.Lock
set adodb = Server.CreateObject("ADODB.Connection")
DBPath = Server.MapPath("DrugInformation.mdb")
adodb.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DBPath
adodb.Execute(SQLstr)
adodb.Close
Application.UnLock
錯誤訊息是
Microsoft OLE DB Provider for ODBC Drivers 錯誤 '80040e14'
[Microsoft][ODBC Microsoft Access Driver] UPDATE 陳述式的語法錯誤。
=======================================================================
請問各位是哪裡錯誤,是SQLstr那邊的錯,還是下面寫進datebase的錯?
謝謝您的回答
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 61.231.194.108
推
01/10 16:26, , 1F
01/10 16:26, 1F
→
01/10 20:17, , 2F
01/10 20:17, 2F
推
01/10 21:41, , 3F
01/10 21:41, 3F
→
01/11 01:12, , 4F
01/11 01:12, 4F
推
01/12 05:20, , 5F
01/12 05:20, 5F
→
01/12 05:26, , 6F
01/12 05:26, 6F
推
01/13 01:25, , 7F
01/13 01:25, 7F