27. juli 2004 - 19:09Der er
14 kommentarer og 1 løsning
Vis kun 5 records!
Hejsa eksperter!
Jeg har et godt script forneden som viser nogle kategorier samt underlæggende sider! jeg vil dog meget gerne nu have den til at kun vise de sidste 5 underliggende sider under hver kategori plus et link til de næste 5 (forrige - næste). jeg har en kode som efter sigende skulle være god, men efter flere timers forsøgen prøver jeg nu her:
min kode som virker som er.............
<% Set rs = Server.CreateObject("ADODB.Recordset") Set conn = Server.CreateObject("ADODB.Connection") conn.Open MM_multiforum_STRING SQL = "SELECT forumcategory.FCID, forumcategory.FCheadline, forumtopic.FTcatkey, forumtopic.FTHEadline, forumtopic.FTID FROM forumcategory LEFT JOIN forumtopic ON forumcategory.FCID=forumtopic.FTcatkey ORDER BY forumcategory.FCID ASC" Set rs = Conn.Execute(SQL)
lastID = "" response.write "<table width=""100%"">" colPrRow = 0 maxPrRow = 2 do while not rs.EOF if colPrRow = 0 then Response.write "<tr>"
if lastID <> rs("FCID") then Response.Write "<td valign=""top"">" response.write "<table width=""100%"">" response.write "<tr><td><b>" & "<img src='replies/images/category.gif' align='absmiddle'><a href='showcategory.asp?FCID=" & rs("FCID") & "'>" & rs("FCheadline") & "</b></td></tr>" lastID = rs("FCID") colPrRow = colPrRow + 1 end if if not rs.EOF then response.write "<tr><td> " & "<a href='topics/showtopic.asp?FTID=" & rs("FTID") & "&FCID=" & rs("FTcatkey") & "'>" & rs("FTHEadline") & "</td></tr>" rs.Movenext end if if not rs.EOF then if lastID <> rs("FCID") then Response.Write "</table>" Response.Write "</td>" end if else Response.Write "</table>" Response.Write "</td>" end if
if colPrRow = maxPrRow then colPrRow = 0 response.write "</tr>" end if loop if colPrRow > 0 then response.write "</tr>" response.write "</table>" %>
loop funktionen som jeg ikke kan finde ud af:O-----
Jeg er helt blank med dette loop! er der nogen der evt. kan skrive det ind i koden for mig hvis jeg smider kr. 150.- oveni - har det stående på paypal.com! håber ikke dette er imod ekspertens regler!!!
Nej desværre jeg kan ikke rigtig finde ud af hvordan jeg skal sætte det ind i min orginale kode!!!
lastID = "" response.write "<table width=""100%"">" colPrRow = 0 maxPrRow = 2 do while not rs.EOF if colPrRow = 0 then Response.write "<tr>"
if lastID <> rs("FCID") then Response.Write "<td valign=""top"">" response.write "<table width=""100%"">" response.write "<tr><td><b>" & "<img src='replies/images/category.gif' align='absmiddle'><a href='showcategory.asp?FCID=" & rs("FCID") & "'>" & rs("FCheadline") & "</b></td></tr>" lastID = rs("FCID") colPrRow = colPrRow + 1 end if if not rs.EOF then response.write "<tr><td> " & "<a href='topics/showtopic.asp?FTID=" & rs("FTID") & "&FCID=" & rs("FTcatkey") & "'>" & rs("FTHEadline") & "</td></tr>" rs.Movenext end if if not rs.EOF then if lastID <> rs("FCID") then Response.Write "</table>" Response.Write "</td>" end if else Response.Write "</table>" Response.Write "</td>" end if
if colPrRow = maxPrRow then colPrRow = 0 response.write "</tr>" end if loop if colPrRow > 0 then response.write "</tr>" response.write "</table>"
<% 'Paging intPage = Request("page") If isNumeric(intPage) = False Or intPage < 1 Then intPage = 1 End If
Set rs = Server.CreateObject("ADODB.Recordset") Set conn = Server.CreateObject("ADODB.Connection") conn.Open MM_multiforum_STRING SQL = "SELECT forumcategory.FCID, forumcategory.FCheadline, forumtopic.FTcatkey, forumtopic.FTHEadline, forumtopic.FTID FROM forumcategory LEFT JOIN forumtopic ON forumcategory.FCID=forumtopic.FTcatkey ORDER BY forumcategory.FCID ASC" rs.Open SQL, Conn, 1
lastID = "" response.write "<table width=""100%"">" colPrRow = 0 maxPrRow = 2 If Not (rs.BOF Or rs.EOF) Then rs.PageSize = 10 rs.AbsolutePage = intPage intRecCount = rs.PageSize intPageCount = rs.PageCount End if do while not rs.EOF And intRecCount > 0 if colPrRow = 0 then Response.write "<tr>"
if lastID <> rs("FCID") then Response.Write "<td valign=""top"">" response.write "<table width=""100%"">" response.write "<tr><td><b>" & "<img src='replies/images/category.gif' align='absmiddle'><a href='showcategory.asp?FCID=" & rs("FCID") & "'>" & rs("FCheadline") & "</b></td></tr>" lastID = rs("FCID") colPrRow = colPrRow + 1 end if if not rs.EOF then response.write "<tr><td> " & "<a href='topics/showtopic.asp?FTID=" & rs("FTID") & "&FCID=" & rs("FTcatkey") & "'>" & rs("FTHEadline") & "</td></tr>" rs.Movenext end if if not rs.EOF then if lastID <> rs("FCID") then Response.Write "</table>" Response.Write "</td>" end if else Response.Write "</table>" Response.Write "</td>" end if
if colPrRow = maxPrRow then colPrRow = 0 response.write "</tr>" end if intRecCount = intRecCount - 1 loop if colPrRow > 0 then response.write "</tr>" response.write "</table>" %>
<% 'Paging Response.Write "<p>Gå til side " For intNum = 1 To intPageCount Response.Write "<a href=?page=" & intNum & ">" & intNum & "</a> " Next
Response.Write "<p>" If Clng(intPage) > 1 Then Response.Write "<a href=?page=" & intPage - 1 & "><<</a>" Else Response.Write "<<" End If
Response.Write " "
If Clng(intPage) < Clng(intPageCount) Then Response.Write "<a href=?page=" & intPage + 1 & ">>></a> " Else Response.Write ">>" End If %>
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.