UC知道请各位帮忙 Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e14'
来源：百度知道 编辑：UC知道 时间：2024/05/23 13:43:27
我想删除掉40条以前的新闻,请高手指点错误所在
Set objRS=conn.Execute("SELECT top 40 id FROM news_url WHERE two_id="&two_id&" order by id desc")
ds=objRS.GetRows
objRS.close
set objRS=nothing
if UBound(ds,2)=39 then
set rssss=conn.execute("delete from news_url where two_id="&two_id&" and id<"&ds(0,39)&" order by id desc")
rssss.close
set rssss=nothing
end if
Set objRS=conn.Execute("SELECT top 40 id FROM news_url WHERE two_id="&two_id&" order by id desc")
ds=objRS.GetRows
objRS.close
set objRS=nothing
if UBound(ds,2)=39 then
set rssss=conn.execute("delete from news_url where two_id="&two_id&" and id<"&ds(0,39)&" order by id desc")
rssss.close
set rssss=nothing
end if
Set objRS=conn.Execute("SELECT top 40 id FROM news_url WHERE two_id="&two_id&" order by id desc")
我记得在这传代码之前有conn.open吧，你这样想一想，你跟数据库的连接还没有中断，并且还在执行当前的查询，不论你是否关闭，又马上执行另一条SQL语句，会不会出错，你应该把数据库连接线关闭了，再执行下一天语句就可以了