15. april 2000 - 12:24
Der er
11 kommentarer og
1 løsning
Udtræk fra db..
Hvordan laver man så der kun kommer de 20 første poster fra dben ud, og så man kan trykke næste og så kommer de næste 20 ud???
Hvordan laver man det???
15. april 2000 - 12:56
#1
Du skal bruge paging her er et eksempel du kan se lidt på:
<%
if len(Request.QueryString("strSearch")) > "0" then
strSearch = Request.QueryString("strSearch")
strSearch = Replace(strSearch, " AND ", "§AND§")
strSearch = Replace(strSearch, " OR ", "§OR§")
strSearch = Replace(strSearch, " and ", "§AND§")
strSearch = Replace(strSearch, " or ", "§OR§")
strSearch = Replace(strSearch, " ", "§AND§")
strSearch = Replace(strSearch, "§AND§", "%' AND cdescription LIKE '%")
strSearch = Replace(strSearch, "§OR§", "%' OR cdescription LIKE '%")
else
strSearch = Trim(Request.Form("Search"))
strSearch = Replace(strSearch, " AND ", "§AND§")
strSearch = Replace(strSearch, " OR ", "§OR§")
strSearch = Replace(strSearch, " and ", "§AND§")
strSearch = Replace(strSearch, " or ", "§OR§")
strSearch = Replace(strSearch, " ", "§AND§")
strSearch = Replace(strSearch, "§AND§", "%' AND cdescription LIKE '%")
strSearch = Replace(strSearch, "§OR§", "%' OR cdescription LIKE '%")
end if
SQL = "SELECT * FROM products WHERE cname LIKE '%" & strSearch & "%' OR cdescription LIKE '%" & strSearch & "%' OR ccategory LIKE '%" & strSearch & "%'ORDER BY cname"
'Tæller antal poster
Set oRs = Conn.Execute(SQL)
Set oRs = Server.CreateObject("ADODB.Recordset")
oRs.Open SQL , Conn , 3
intPage = Request("page")
If isNumeric(intPage) = False Or intPage < 1 Then
intPage = 1
End If
Set Result = Server.CreateObject("ADODB.RecordSet")
Result.Open SQL, Conn, adOpenKeySet, adLockReadOnly
if request.form("search") = "" and len(Request.QueryString("strSearch")) = 0 then
response.write "<table width=300 border=0 cellpadding=0 cellspacing=0><tr><td><span class=subheader>Du har ikke skrevet et søgeord<br><hr width=205 noshade size=3 align=left color=#0C6931></SPAN></td></tr></table>"
else
if Result.Eof then
Response.Write "<table width=300 border=0 cellpadding=0 cellspacing=0><tr><td><span class=subheader>Din søgning gav desværre intet resultat<br><hr width=262 noshade size=3 align=left color=#0C6931></SPAN></td></tr></table>"
else
Response.Write "<table width=300 border=0 cellpadding=0 cellspacing=0><tr><td><span class=subheader>Søgning på LKP resulterede i:<br><hr width=240 noshade size=3 align=left color=#0C6931></SPAN></td></tr></table>"
'Paging
If Not (result.BOF Or result.EOF) Then
Result.pagesize = 10
Result.AbsolutePage = intPage
intRecCount = Result.PageSize
intPageCount = Result.PageCount
'Udskriver antallet af poster
antal = oRs.recordcount
response.write "<span class=text><i>Din søgning gav " & antal & " resultater - "
Response.Write "side " & intPage & " af " & intPageCount & "</i></span><br><br>"
Do While Not Result.EOF And intRecCount > 0
intRecCount = intRecCount - 1
x = x + 1
if x = 10 then
decade = intpage
i = 0
else
i = mid(x,1,1)
decade = intpage - 1
end if
Response.Write "<table border=""0"" width=""350"" cellpadding=0 >"
Response.Write "<tr><td width=""350"">" & "<span class=subheader><a href=produkter.asp?mode=produkt&id=" & Result("catalogID") & ">" & decade & i & ". " & Result("cname") & "</SPAN></a><br>"
Response.Write "<span class=text>" & Left(Result("cdescription"),100) & "..." & "</SPAN><br>"
Response.Write "<span class=text><a href=produkter.asp?mode=produkt&id=" & Result("catalogID") & ">" & "Læs side" & " <img src=images/link_arrow.gif border=0>" & "</a>" & "</SPAN><br><br></td></tr></table>"
Result.Movenext
loop
end if
end if
end if
end if
Result.Close
Set Result = nothing
'Response.Write "<span class=subheader>Gå til side "
Response.Write "<span class=subheader>"
If Clng(intPage) > 1 Then
Response.Write "<a href=site_search.asp?page=" & intPage - 1 & "&strSearch=" & strSearch & "><img src=images/tilbage.gif border=0 align=left vspace=1 hspace=3></a> "
Else
Response.Write ""
End If
For intNum = 1 To intPageCount
Response.Write " <a href=site_search.asp?page=" & intNum & "&strSearch=" & strSearch & ">" & intNum & "</a> "
Next
Response.Write " "
If Clng(intPage) < Clng(intPageCount) Then
Response.Write "<a href=site_search.asp?page=" & intPage + 1 & "&strSearch=" & strSearch & "><img src=images/frem.gif border=0 valign=center></a> "
Else
Response.Write ""
End If
%>
16. april 2000 - 15:40
#4
netsrac>>>
jo, men så kan man ik trykke næste, så de 20 næste kommer fre....
18. april 2000 - 13:48
#9
Mange, nej ved det ik, hvad skal du bruge det til ?? Bliver der ændret i databasen eller er den fast ??