delete from 问题

显示全部楼层 · 2008-11-26 10:18:47

"" then
sql="delete from sanji where id="&cint(id)&""
conn.execute sql
sql="delete from news where smallclassname='" &smallclassname& "' and sanji='" &sanji& "' "
conn.execute sql
end if
call closeconn()

response.redirect "classmanage.asp"
%>
大家帮我看下这句,为什么第二个sql语句不执行.就是删除news里面的一条记录,删除不了.
谁帮我看下原因.

千问 · 2008-11-26 10:18:47

这样：sql="delete from news where smallclassname=ltrim(rtrim('" &smallclassname& "')) and sanji=ltrim(rtrim('" &sanji& "')) "...