Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e07'

[Microsoft][ODBC SQL Server Driver][SQL Server]将 varchar 值 '4360994, 4360993, 4360992' 转换为数据类型为 int 的列时发生语法错误。

/manager/admin/savemerchant.asp，行 18

把18行附近的代码发上来看看呗

dim userid,action
action=request.QueryString("action")
userid=request.QueryString("id")
if userid="" then userid=request("userid")
conn.execute "delete from corporation where user_id='"&userid&"'"
conn.execute "delete from cs_company where user_id='"&userid&"'"
'response.Redirect "manageuser.asp"
response.Redirect request.servervariables("http_referer")
%>

你是做批量删除吧,改成
conn.execute "delete from corporation where user_id in("&userid&")"
conn.execute "delete from cs_company where user_id in("&userid&")"

可能是userid没有值.

你在数据库中的字段user_id是int型的，而你的SQL语句“"delete from corporation where user_id='"&userid&"'"”却是把userid当成了字符型，如果你确定userid中的值是一个数字，那么就将SQL语句改为：
delete from corporation where user_id="&userid&""
就OK了

问题已解决