%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <% 'DECLARATIONS POUR LA PAGINATION --------------------------------------------------------------------------- Const EntTaillePage=50 Dim EntPageCourante, BaseLink, BaseSet, varSQL Dim EntTotalPage, intI, connstring ' OUVERTURE BASE #################################################################################### Set BaseLink=Server.CreateObject("ADODB.Connection") connstring="DRIVER={Microsoft Access Driver (*.mdb)}; " & "DBQ=" & Server.MapPath("../") & "/databases/emcollections.mdb" BaseLink.Open connstring ' OUVERTURE TABLE ----------------------------------------------------------------------------------------- varSQL = "SELECT * FROM client where client_numero>0" varSQL = varSQL & " ORDER BY client_numero desc" Set BaseSet= Server.CreateObject("ADODB.Recordset") BaseSet.CursorType = adOpenStatic BaseSet.CacheSize = EntTaillePage BaseSet.Open varSQL, BaseLink, 3, 3 'CONFIGURATION NUM PAGE EN COURS ---------------------------------------------------------------------- If Request.Form("Action")="" Then if request.querystring("mapage") ="" then EntPageCourante=1 else EntPageCourante = cint(request.querystring("mapage")) end if Else EntPageCourante = CInt(Request.Form("PageCourante")) Select Case Request.Form("Action") Case "Page Précédente" EntPageCourante = EntPageCourante - 1 Case "Page Suivante" EntPageCourante = EntPageCourante + 1 End Select End If if Request.querystring("page") = "Suivant" then EntPageCourante = EntPageCourante + 1 end if baseset.PageSize = EntTaillePage If Not baseset.EOF Then baseset.AbsolutePage=EntPageCourante EntTotalPage = baseset.PageCount EntTotalEnregistrement = baseset.recordCount %>
|
|
|
|
|
|
|
|
|
|
|
|
|