% Set Conntemp=Server.CreateObject("ADODB.Connection") Connstrtemp="DBQ="+server.mappath("persons.mdb")+";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};DriverId=25;FIL=MS Access;ImplicitCommitSync=Yes;MaxBufferSize=512;MaxScanRows=8;PageTimeout=5;SafeTransactions=0;Threads=3;UserCommitSync=Yes;" Conntemp.Open connstrtemp set rstemp=Server.CreateObject("ADODB.Recordset") sqlsql="select * from persons order by id desc" rstemp.open sqlsql,Conntemp,3 Set Conntempcolumn=Server.CreateObject("ADODB.Connection") Connstrtempcolumn="DBQ="+server.mappath("album.mdb")+";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};DriverId=25;FIL=MS Access;ImplicitCommitSync=Yes;MaxBufferSize=512;MaxScanRows=8;PageTimeout=5;SafeTransactions=0;Threads=3;UserCommitSync=Yes;" Conntempcolumn.Open connstrtempcolumn set rstempcolumn=Server.CreateObject("ADODB.Recordset") sqlsql="select * from persons order by id desc" rstempcolumn.open sqlsql,Conntempcolumn,3 sql="select * from topic " set rs=Server.CreateObject("ADODB.Recordset") begincolumn() %>
|
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 共 <%=no%> 条,当前第 <%=pg%>/<%=rstemp.pagecount%> 页,每页 10 条 <% if pg<>1 then %> 首页 上页 <% end if if pg<>rstemp.pagecount then %> 下页 尾页 | <% end if if rstemp.recordcount>10 then %><% end if %> |