日期:2014-05-17  浏览次数:20860 次

帮我卡看哪里写错了?
jdescription和position都有值,可就是写不进库里,什么问题?
SqlStr   =   "select   *   from   admin   where   position= "&position& " "
Set   Rs   =   Server.CreateObject( "adodb.recordset ")
Rs.Open   SqlStr,   Conn,   1,   3
if   not(rs.eof   and   rs.bof)   then
response.write( " <script> alert( " "该管理职位已存在!请重新输入 " ");location.href= " "admin_position.asp?action=add " "; </script> ")
response.end          
else
Rs.Addnew
Rs( "position ")   =   position
Rs( "description ")   =   jdescription
Rs.Update
Rs.Close
Set   Rs   =   Nothing
end   if

------解决方案--------------------
SqlStr = "select * from admin where position= ' "&position& " ' "