UC知道在一个网页面如何做多次对数据库的sql查询
来源：百度知道 编辑：UC知道 时间：2024/06/01 13:18:40
sql="select * from P_product where cid=78"
sql=sql&" order by P_ID desc"
rs.open sql,conn,1,1
.....
rs.close
set rs=nothing
.........
.........
........
sql="select * from P_product where cid=80"
sql=sql&" order by P_ID desc"
rs.open sql,conn,1,1
.......
rs.close
set rs=nothing
.
.
.
//*运行时就会出现
Microsoft VBScript 运行时错误 错误 '800a01a8'
缺少对象
/xt/index01.asp，行422
*//的错误提示
是第一个前面加，还是在第二个sql前加
sql=sql&" order by P_ID desc"
rs.open sql,conn,1,1
.....
rs.close
set rs=nothing
.........
.........
........
sql="select * from P_product where cid=80"
sql=sql&" order by P_ID desc"
rs.open sql,conn,1,1
.......
rs.close
set rs=nothing
.
.
.
//*运行时就会出现
Microsoft VBScript 运行时错误 错误 '800a01a8'
缺少对象
/xt/index01.asp，行422
*//的错误提示
是第一个前面加，还是在第二个sql前加
set rs1=server.createObject("adodb.recordset")
sql1="select * from P_product where cid=78"
sql1=sql1&" order by P_ID desc"
rs1.open sql1,conn,1,1
.....
rs1.close
set rs1=nothing
.........
.........
........
set rs2=server.createObject("adodb.recordset")
sql2="select * from P_product where cid=80"
sql2=sql2&" order by P_ID desc"
rs2.open sql2,conn,1,1
.......
rs2.close
set rs2=nothing
建立多个记录集就行
Dim MM_conn_STRING
MM_conn_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&Server.MapPath("data.mdb")
'记录集一
Set show = Server.CreateObject("ADODB.Recordset")
show.open "SELECT * FROM notes ORDER BY n_time DESC",MM_conn_STRING,1,1
显示show("字段")
show.Close()
Set show = Nothing
'记录集二
Set show2 =