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我在前面声明并且赋值了
