数据库删除问题,貌似是变量传递出错,没分了,麻烦大家帮忙看看
case "del"
set rs=server.CreateObject("adodb.recordset")
rs.open "select userid ,username from [user] where userid="&userid,conn1,3
dim username
username=rs("username")
conn.execute ("delete from [user] where userid="&request.form("userid"))
conn.execute ("delete from orders where userid="&request.form("userid"))
conn.execute ("delete from switch where username='"&username&"'")
rs.update
rs.close
set rs=nothing
response.Redirect "b2b_user.asp"
大家帮我看看这段代码为什么删不掉switch表单里面的相应项,我调试的时候直接给username赋我想要的值可以正确删除,但是直接给userid赋值,既是
rs.open "select userid ,username from [user] where userid=78“,conn1,3
就不能操作,而且我出错只是conn.execute ("delete from switch where username='"&username&"'")出错,另外两个是正确的,也是说userid传值正确
而且我吧rs.open "select userid ,username from [user] where userid="&userid,conn1,3改为
rs.open "select userid ,username from [user] where userid="&request.form("userid"),conn1,3也不行
userid我在前面声明并且赋值了