Microsoft OLE DB Provider for ODBC Drivers 錯誤 Microsoft OLE DB Provider for ODBC Drivers 錯誤 \'80040e14\'Microsoft OLE DB Provider for ODBC Drivers 錯誤 \'80040e14\' [Microsoft][ODBC Microsoft Access 驅(qū)動程序] 語法錯誤 (操作符丟失) 在查詢表達(dá)式 \'wenzhang WHERE id=6\' 中。 /sxiutext.asp，行9 以下是ASP:<%dim tidtid=request.querystring(\"id\")dim cnn,xacset cnn=server.createobject(\"ADODB.connection\")cnn.connectionstring=\"DRIVER={microsoft access Driver (*.mdb)};DBQ=\" & Server.mappath(\"zhuyei.mdb\")cnn.openxac=\"DELETE wenzhang WHERE id=\" & request.querystring(\"id\")cnn.execute xac, , adcmdtextcnn.closeset cnn=nothing%>

熱心網(wǎng)友

xac=\"DELETE wenzhang WHERE id=\" & request.querystring(\"id\")換成:xac=\"DELETE * form wenzhang WHERE id=\" & request.querystring(\"id\")

熱心網(wǎng)友

request.querystring(\\\"id\\\")是String型,要轉(zhuǎn)換成Int型,你的id是數(shù)值,不是string.另外聲明最好給出類型.

熱心網(wǎng)友

數(shù)據(jù)庫連接問題把所有“/”去掉就OK