高手帮忙啊!!
sql="
if exists(select * from T_USER where USER_MOBILE='13200000444' and DEL_FLAG=0)
begin select Ret=0 end
else
begin
if exists(select * from T_USER where USER_MOBILE='13200000444' and DEL_FLAG=1)
begin update T_USER set USER_NAME ='',USER_PWD = '9204',USER_SEX = '0', USER_BLOOD = '',USER_BIRTHDAY = '19800101',USER_POSTCODE = '', USER_ADDRESS = '',USER_EMAIL = '', USER_LIKE = '',USER_COMMENT = '', USER_DATE_NEW = '2003-9-12 9:07:16',USER_DATE_LAST = '2003-9-12 9:07:16',USER_CREATOR = '13200000444', USER_MENDER = '13200000444',USER_FEE = 0,DEL_FLAG = 0 where USER_MOBILE = '13200000444' end
else
begin insert T_USER (USER_MOBILE,USER_NAME,USER_PWD,USER_SEX,USER_BLOOD,USER_BIRTHDAY,USER_POSTCODE,USER_ADDRESS, USER_EMAIL,USER_LIKE,USER_COMMENT,USER_DATE_NEW,USER_DATE_LAST,USER_CREATOR,USER_MENDER,USER_FEE,DEL_FLAG) values ('13200000444','','9204','0', '','19800101','','', '','','', '2003-9-12 9:07:16','2003-9-12 9:07:16','13200000444','13200000444',0,0) declare @USER_ID int select @USER_ID=USER_ID from T_USER where USER_MOBILE='13200000444' and DEL_FLAG=0 insert T_WAB (USER_ID,WAB_NAME,WAB_DATE_NEW,WAB_DATE_LAST,WAB_CREATOR,WAB_MENDER,WAB_FLAG) values (@USER_ID,'MYWAB','2003-9-12 9:07:16','2003-9-12 9:07:16','13200000444','13200000444','1') declare @BUSI_ID int select @BUSI_ID=BUSI_ID from T_BUSINESS where BUSI_NAME = '用户管理' insert T_USER_BUSI (USER_ID,BUSI_ID,DELAY_FLAG,BUSI_FLAG) values (@USER_ID,@BUSI_ID,'0','0') insert T_OPER (USER_ID,OPER_TIME,USER_MOBILE,MO_NO,BUSI_ID,OPER_FLAG,OPER_PARA,OPER_MAN) values (@USER_ID,'2003-9-12 9:07:16','13200000444','20030912090716000',@BUSI_ID,'5','192.168.0.110','13200000444') end
select Ret=1 end "
set rs=con.execute(sql)
response.write rs("Ret")
上面的错误提示是:ADODB.Recordset 错误 '800a0cc1'
在对应所需名称或序数的集合中,未找到项目。
为什么会出现上面的情况,sql语句没有错误,我在查询分析器中执行通过,都有表返回