|
|
<% dim con,rst,scriptname,gen,holder,edu,age1,age2,stat,strsql,i,bgcolor,count,newkey newkey=Request.Querystring("key") i=1 dim TotalPages,NumPerPage,CurrentPage,Number,counter, keyskill, jobspeci set con=Server.CreateObject("ADODB.Connection") con.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&Server.MapPath("pusitab.mdb")&";") set rst=Server.CreateObject("ADODB.Recordset") strsql= "SELECT * FROM newstab WHERE ngroup='" & Request.Querystring("key") &"' " rst.Open strsql,con,1,2 if Request.Querystring("NumPerPage")<>0 then NumPerPage=Int(request("NumPerPage")) else NumPerPage=10 end if If Request.Querystring("page")="" then CurrentPage=1 else CurrentPage=cint(Request.Querystring("page")) end if number=rst.RecordCount if NOT rst.eof then rst.MoveFirst rst.PageSize=NumPerPage TotalPages=rst.PageCount rst.AbsolutePage=CurrentPage end if %> <%response.write(rst.Recordcount)%>
|
|||||||||||||||