一个ASP页面可以同时存在几个Recordset???
我在做一个页面的时候要同时用到4个Recordset
将4个表中的记录输出到页面中
但总是有错误
set conn=server.CreateObject ("adodb.connection")
conn.Open "driver={SQL Server};server=(local);UID=sa;PWD=;database=wpos"
set rs=server.CreateObject("ADODB.Recordset")
rs.Open "Select * from d_rireki",conn,1,1
set rs1=server.CreateObject("ADODB.Recordset")
rs1.Open "Select shohin_mei,picture_o from m_shohin where shohin_cd=" & rs("shohin_cd"),conn,1,1
set rs2=server.CreateObject("ADODB.Recordset")
rs2.Open "Select tenpo_mei,address,nohinbasyo_cd from m_tenpo where tenpo_cd=" & rs("tenpo_cd"),conn,1,1
set rs3=server.CreateObject("ADODB.Recordset")
rs3.Open "Select nohinbasyo_mei from m_nohinbasyo where nohinbasyo_cd=" & rs2("nohinbasyo_cd"),conn,1,1
在后面附值的时候
总是说有错
想问问到底同时支持几个啊