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

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")