您所在位置：主题：关于删除，很纳闷！！！
mshaosjm
[专家分：10] 发布于 2007-02-07 11:11:00
下面是我 的删除语句，数据库中定义id为char类型的，如果数据是数字的能删，当有字母是就删不了，为什么？
<%
if request("submit")="删除" then
connstr="Provider = sqloledb;driver={sql server};+server=SHAOSJM-8BC9D56;database=asp;uid=sa;pwd=sa"
set conn=server.CreateObject("ADODB.Connection")
conn.open connstr
dim idb
idb=request("checkbox")
sql="delete from nam where id in("&idb&")"
conn.execute sql
response.Redirect("xiugai.asp")
conn.close
set conn=nothing
end if
%>
<%
if request("submit")="删除" then
connstr="Provider = sqloledb;driver={sql server};+server=SHAOSJM-8BC9D56;database=asp;uid=sa;pwd=sa"
set conn=server.CreateObject("ADODB.Connection")
conn.open connstr
dim idb
idb=request("checkbox")
sql="delete from nam where id in("&idb&")"
conn.execute sql
response.Redirect("xiugai.asp")
conn.close
set conn=nothing
end if
%>
