我程序中从前面一个页面传递过来一个值,后面的页面接收此值,并进行相应处理
部分代码段:
dim carid
carid = Request.QueryString("car_id")
delcar = "delete * from VehicleInfo Where carid ="&carid
set deltemp = Server.CreateObject("ADODB.RecordSet")
deltemp.open delcar,conn,1,3
提示错误:
Microsoft OLE DB Provider for SQL Server (0x80040E14)
第 1 行: '*' 附近有语法错误
其中数据库表中的carid为numeric型,我用Response.Write("carid")检查前面页面传来的值,值是正确的.
dim carid
carid = Request.QueryString("car_id")
delcar = "delete * from VehicleInfo Where carid ="&carid
conn.execute(delcar)
dim carid
carid = Request.QueryString("car_id")
delcar = "delete from VehicleInfo Where carid ='"&carid&"'"
conn.execute(delcar)
作为字符串处理会报下面的错
Microsoft OLE DB Provider for SQL Server (0x80040E07)
将数据类型 varchar 转换为 numeric 时出错。
dim carid
carid = clng(Request.QueryString("car_id"))
delcar = "delete from VehicleInfo Where carid ="&carid
conn.execute(delcar)
dim carid
carid = Request.QueryString("car_id")
delcar = "delete * from VehicleInfo Where carid ='"&carid & "'"
conn.execute(delcar)
你可以把delcar 变量response.wirte出来，再复制到查询分析器中执行。我觉得错误大概处在where语句那里
response.write delcar
把delcar输出来看看，再把语句放到SQL里面看看查询结果，分析原因
sql="delete * from VehicleInfo where carid='"&carid&"'"
这样改就行了