Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'id='.
/newsscript/canc.asp, line 8
Non capisco il perchè??codice:<html> <% Set Connect = Server.CreateObject("ADODB.Connection") Connect.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & server.MapPath("/mdb-database/db.mdb") cod=Request.Querystring("cod") strSQL = "DELETE FROM news WHERE id="&cod Connect.Execute(strSQL) %> <hr color ="red" size="1"> <font face="verdana" size="2"> Cancellato con successo</font> <hr color ="red" size="1"> </html>

Rispondi quotando