this is ASP.NET, not ASP, but tryConn.Execute("Delete From users Where id="&Request.QueryString("id"))orConn.Execute("Delete From users Where id='"&Request.QueryString("id") & "'")
if your id is not a number, you need to enclose the literal string in '....'
还有一个: Conn.Execute("Select * From users Where id="&Request.QueryString("id"))同样的错误: 错误类型: Microsoft OLE DB Provider for ODBC Drivers (0x80040E10) [Microsoft][ODBC Microsoft Access Driver] 参数不足,期待是 1。再试试你的2个方法Conn.Execute("Select From users Where id="&Request.QueryString("id")) Conn.Execute("Select From users Where id='"&Request.QueryString("id") & "'")结果: 错误类型: Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC Microsoft Access Driver] SELECT 子句中包含一个保留字、拼写错误或丢失的参数,或标点符号不正确。麻烦再帮帮偶!谢谢!!!
Conn.Execute("Select * From users Where id="&Request.QueryString("id")) Conn.Execute("Select * From users Where id='"&Request.QueryString("id") & "'")
Conn.Execute("Select * From users Where id="&Request.QueryString("id"))同样的错误:
错误类型:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] 参数不足,期待是 1。再试试你的2个方法Conn.Execute("Select From users Where id="&Request.QueryString("id"))
Conn.Execute("Select From users Where id='"&Request.QueryString("id") & "'")结果:
错误类型:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] SELECT 子句中包含一个保留字、拼写错误或丢失的参数,或标点符号不正确。麻烦再帮帮偶!谢谢!!!
Conn.Execute("Select * From users Where id="&Request.QueryString("id"))
Conn.Execute("Select * From users Where id='"&Request.QueryString("id") & "'")