助:asp程序中出现的问题

来源：百度知道 编辑：UC知道 时间：2024/05/27 17:36:58
错误类型：
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]第 1 行: '*' 附近有语法错误。
/1/2002716114847_75960/公司通讯录/Jaddress1.0/addrdel.asp, 第 14 行
程序如下:

<!--#include file="db.asp"-->
<!--#include file="session.asp"-->
<%sort=request.Form("sort")
id=request.Form("id")
if sort="comp" then
strSql = "delete * from cp where id="& id
conn.Execute strSql
strSql = "delete * from address where cmp='"& id
conn.Execute strSql
conn.Close
response.redirect "listcomp.asp"
else
strSql = "delete * from address where id="& id
conn.Execute strSql <--------出错行
conn.Close
response.redirect "listmember.asp"
end if%>
删除了delete语句中的*号也不行.请高手指教,谢谢!

strSql = "delete * from address where cmp='"& id

你这句就有问题啊！多了一个'

仔细看看！

出错如果是strSql = "delete * from address where id="& id 这句的话

你看看ID字段是不是数字型的？或者传过来的id是不是数字型的？写成这样试试

strSql = "delete * from address where id='"&id&"'"

strSql = "delete * from cp where id="& id
conn.Execute strSql
strSql = "delete * from address where cmp='"& id
conn.Execute strSql
conn.Close
response.redirect "listcomp.asp"
else
strSql = "delete * from address where id="& id

改为
strSql = "delete from cp where id="& id
conn.Execute strSql
strSql = "delete from address where cmp="& id
conn.Execute strSql
conn.Close
response.redirect "listcomp.asp"
else
strSql = "delete from address where id="& id

数意看字段类型,分清字符型用 '