为什么在SQL查询器和asp记录集里得到的结果不一样?是不是提交的语句太多，两个循环

[yaodayizi]

for k=0 to ubound(taskIdArray)
for i=0 to ubound(idxArray)

sqlx="select id,taskType from task where assignUserid like '%"&idxArray(i)&",%' and state not in (3,4) and id ="&taskIdArray(k)

set rsx=conn.execute(sqlx)
startSql1=""
startSql2=""
if not rsx.eof then

do while not rsx.eof
startSql1="update task set state=3,startTime='"&now()&"' where id="&rsx("id")
'startSql12="update taskGroup set state=3,startTime='"&now()&"' where id="&rs("id")
startSql3="update taskEmployee set state=3,startTime='"&now()&"' where fid=0 and id="&rsx("id")
conn.execute(startSql1)
'conn.execute(startSql3)
'info="系统自动设置ID为 "&taskIdArray(i)&" 的工作计划状态为进行中"
'recordAdd "设置状态",rsx("id"),"task",3,"task",info
response.write rsx("id")&" taskName= "&rsx("taskType")&"<br>"&startsql1&"<br>"&startsql3&"<br>"
rsx.movenext
loop
end if
rsx.close
set rsx=nothing
'response.write rsx("id")
next
next

[yaodayizi]

这里是生成的语句
select id,taskType from task where assignUserid like '%2,%' and state not in (3,4) and id =3
False
False
3 taskName= 页面版式修改
update task set state=3,startTime='2006-8-23 1:42:54' where id=3
update taskEmployee set state=3,startTime='2006-8-23 1:42:54' where fid=0 and id=3

select id,taskType from task where assignUserid like '%2,%' and state not in (3,4) and id =4
False
False
4 taskName= 普通图片修改
update task set state=3,startTime='2006-8-23 1:42:54' where id=4
update taskEmployee set state=3,startTime='2006-8-23 1:42:54' where fid=0 and id=4

[longli67]

你在程序中response.write(sql)出来和分析器里对比一下你的语句，估计问题就找出来了！