ASP分页问题

显示全部楼层 · 2008-10-28 15:06:47

set conn = server.createobject("adodb.connection")
conn.open = "provider=microsoft.jet.oledb.4.0;" & "data source = " & server.mappath("icc.mdb")
cp="Select * from 车牌"
set rscp=server.createobject("adodb.recordset")
rscp.open cp,conn,3,3
以上是我的数据链接,"车牌"中有"自动编号、车牌号码、生产企业"三栏,我想将"某生产业"分页显示出来,请问代码要怎么写.
例如要分页只显示"上海通用"的"车牌号码",就显示"上海通用"的所有车牌号码,每页6条信息(其它生产企业的信息不出现)

千问 · 2008-10-28 15:06:47

把beijian_list.asp改成当前文件名<%set conn = server.createobject("adodb.connection") conn.open = "provider=microsoft.jet.oledb.4.0;" & "data source = " & server.mappath("icc.mdb") cp="Select * from 车牌" set rscpcp=server.createobject("adodb.recordset") rscpcp.open cp,conn,3,3TotalRecords=rscp.RecordCount
pmcount...

千问 · 2008-10-28 15:06:47

<%set conn = server.createobject("adodb.connection") conn.open = "provider=microsoft.jet.oledb.4.0;" & "data source = " & server.mappath("icc.mdb") cp="Select * from 车牌 where 生...

千问 · 2008-10-28 15:06:47

楼上的两位可真用心！值得顶！...