Avatar billede mille Nybegynder
18. november 1999 - 09:55 Der er 2 kommentarer

Hvad er der galt ?

Jeg prøvede at sætte Paging af et recordset ind i dette script, MEN..

En anden ting er hvordan laver man sådanne at ./images/egenside1.gif kun bliver vist hvis der er et link at vise ??



<% ShowHeader("List by Category") %>
<%

Session.LCID = 1030
Dim Connect, Klasse, Query, Category
Category = Trim(Request("Category"))
If Category = "" Then
  Response.Write "No Category specified.<p>"
Else
  Set Connect = Server.CreateObject("ADODB.Connection")
  Connect.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("testbase") & ";DefaultDir=\;DriverId=25;FIL=MS Access;MaxBufferSize=512;PageTimeout=5"

  Query = "SELECT ItemNum,Item,Description,Price,State,Email,Url FROM Items "
  Query = Query & "WHERE Category='" & Category & "'"
  Set Klasse = Connect.Execute(Query)

'Number of Items per page
NumPages =10

%>

<p align="left"><font size="4"><b><%=Category%>
</font>
<table border="0" width="600" cellspacing="0" cellpadding="0">
  <tr>
    <td width="445" valign="top"><div align="center"><center>

<table border="1" bgcolor="#FFFFFF" width="444" bordercolor="#FFFFFF" cellspacing="0"
cellpadding="5">
  <tr>
    <th align="left" width="403" bgcolor="#000080" style="background-color: #000080"><small><font color="#FFFFFF" face="Tahoma">Emne</font></small></th>
    <th align="center" width="27" bgcolor="#000080" style="background-color: #000080" valign="middle"><small><font color="#FFFFFF" face="Tahoma">Pris</font></small></th>
    <th align="center" width="30" bgcolor="#000080" style="background-color: #000080" valign="middle"><small><font color="#FFFFFF" face="Tahoma">By</font></small></th>
  </tr>
<%
  Do While Not Klasse.EOF %>
 
  <%
' Something found
TotalRows = klasse.RecordCount

klasse.PageSize = NumPages
TotalPages=klasse.PageCount

select case Request.QueryString("move")
    case "first" pageNo = 1  '  First
    case "previous" pageNo = cint(Session("page_num")) - 1  '  Next
    case "next" pageNo = cint(Session("page_num")) + 1  '  Previous
    case "last" pageNo = TotalPages  '  Last
    case Else PageNo = 1
End Select

if cint(PageNo) < 1 then PageNo = 1
if cint(PageNo) > TotalPages then pageNo = TotalPages

klasse.AbsolutePage = PageNo
PageNumber=PageNo
Session("page_num") = PageNo

HowMany = 0
Response.Write "<div align='left'><table border='0' width='400'>"
Do until klasse.EOF or HowMany => NumPages
%>

  <tr>
<td bgcolor="#EFEFEF" align="left" valign="middle" height="40"><small><a href="detail.asp?item=<%=Klasse("ItemNum")%>"><%=Klasse("Item")%></a></small><br><font face="Arial" size="2"><%=Klasse("Description") & " "%><%=Klasse("State")& " - "%></font></td>
    <td bgcolor="#EFEFEF" align="center" valign="middle" height="40"><small><a href="mailto:<%=Klasse("Email")%>"
    target="_blank"><img border="0" src="./images/email.gif" alt="Email" width="14" height="11"></a></p>
    <td bgcolor="#EFEFEF" align="center" valign="middle" height="40"><small><a href="http://<%=Klasse("Url")%>"
    target="_blank"><img border="0" src="./images/egenside1.gif" alt="Internetside" width="18" height="22"></a></p>
</td>
  </tr>
<%
  Klasse.MoveNext
  howmany = howmany + 1   
  Loop
  %>
<%Response.Write "</table>"%>
<%' set klasse = klasse.NextRecordset %>
<%Response.Write "<a href='foreningssider.asp?mode=show&move=previous'"%>target="_self"><img border="0" src="./images/forrigeside.gif" alt="Internetside" width="81" height="29"></a></p>
<%Response.Write "<a href='foreningssider.asp?mode=show&move=next'"%>target="_self"><img border="0" src="./images/naesteside.gif" alt="Internetside" width="81" height="29"></a></p>
<%
Connect.close
set Connect = nothing
%>
  <tr>
      <td><p align="right"><font face="Veranda, Arial" size="2" ><%= PageNumber %>
        af <%= TotalPages %> sider</p>
    <p align="left"><font color="#000080"><%
End sub

End If
%>


/mille
Avatar billede mille Nybegynder
18. november 1999 - 22:29 #1
Fandt det selv

<% if Klasse("Email") <> "" then %><bla. bla. bla.><% else %>

Men mangler stadig et svar på hvordan jeg indsætter paging record........
Avatar billede s Nybegynder
27. november 1999 - 20:11 #2
Du kan lave paging således:

'Antal resultater pr side
reprside = 10

Connection = "DRIVER={Microsoft Access Driver (*.mdb)}; UID=Sysop; PWD=14578; DBQ=" & Server.Mappath("data.mdb")

Set Conn = Server.CreateObject("ADODB.connection")
Conn.open Connection

Set rs = Server.CreateObject("ADODB.recordset")

Sql = "SELECT * FROM tabelnavn ORDER BY id"
rs.Open Sql, Conn, 1, 1

if rs.bof or rs.eof then
%>
<center><br><br><br><br><b>Desværre fandtes der ikke nogle felter i databasen der svare til deres forespørgsel!</b></center>
<%

end if

TotalRows = rs.RecordCount

rs.PageSize = reprside
TotalPages = rs.PageCount

select case request.QueryString("move")
    case "first" pageNo = 1
    case "previous" pageNo = cint(Session("page_num")) - 1
    case "next" pageNo = cint(Session("page_num")) + 1
    case "last" pageNo = TotalPages
    case Else PageNo = 1
end selsect

if cint(PageNo) < 1 then PageNo = 1
if cint(PageNo) > TotalPages then pageNo = TotalPages

rs.AbsolutePage = PageNo
PageNumber = PageNo

Session("page_num") = PageNo

do until rs.eof
...
rs.MoveNext
loop
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Kurser inden for grundlæggende programmering

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester