当前位置: 代码迷 >> ASP >> 如何会这样? ADODB.Recordset (0x800A0CC1)在对应所需名称或序数的集合中,未找到项目
  详细解决方案

如何会这样? ADODB.Recordset (0x800A0CC1)在对应所需名称或序数的集合中,未找到项目

热度:966   发布时间:2012-04-02 19:58:59.0
怎么会这样? ADODB.Recordset (0x800A0CC1)在对应所需名称或序数的集合中,未找到项目。
源代码   请高手帮忙一下,十分感谢!
<%
set   rst=server.CreateObject( "adodb.recordset ")
rst.open   "select   *   from   user   where   u_user= ' "   &   request.Form( "f_user ")   &   " ' ",conn   ,1,1
if   rst.recordcount> 0   then
response.Write   "用户名: "   &   request.Form( "f_user ")   &   "已经被占用,请点后退按钮返回上一页! "
rst.close
set   rst=nothing
conn.close
set   conn=nothing
response.End
else  
'set   rst1=conn.execute( "insert   into   user   (u_user,u_code)   values   ( ' "   &   request.Form( "f_user ")   &   " ', ' "   &   request.Form( "f_code ")   &   " ') ")
rst.close

rst.open   "user ",conn,1,3
rst.addnew
rst( "u_user ")=request.Form( "f_user ")
rst( "u_code ")=request.Form( "f_code ")
rst.update
rst.close

set   rst1=conn.execute( "select   @@identity   as   uid ")
uid=rst1(uid)
rst.open   "info ",conn,1,3
rst.addnew
rst( "i_uid ")=uid
rst( "i_name ")=request.Form( "f_name ")
rst( "i_sex ")=request.Form( "f_sex ")
rst( "i_age ")=request.Form( "f_age ")
rst( "i_vip ")=false
rst.update
rst.close

end   if
%>


------解决方案--------------------
检查数据库中的字段名跟代码中是否完全一样.肯定是有不一样。你写错的。
  相关解决方案