ASP中操作数据库中的记录集(急)
来源:百度知道 编辑:UC知道 时间:2024/05/16 20:41:08
我这样写对么?? set rs=conn.execute"select * from users"
if not rs.eof then
======
else
set rs=nothing
set rs=conn.execute"select * from users2"
if not rs.eof then
===
else
set rs=conn.execute"select * from users3"
end if
end if
rs.close
if not rs.eof then
======
else
set rs=nothing
set rs=conn.execute"select * from users2"
if not rs.eof then
===
else
set rs=conn.execute"select * from users3"
end if
end if
rs.close
set rs=conn.execute"select * from users2"
这句,你把它分开写试试
SQL="select * from users2"
set rs=conn.execute(sql)
Set Rs=SERVER.CreateObject("ADODB.RecordSet")
好像可以吧.
运行机一下试试吧
Set Rs=SERVER.CreateObject("ADODB.RecordSet")
真是感叹!
最上面加Set Rs=SERVER.CreateObject("ADODB.RecordSet")
然后把类似set rs=conn.execute"select * from users" 改为
set rs=conn.execute("select * from users")