Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

recordset paging

Status
Not open for further replies.

amiw

Programmer
Apr 1, 2003
113
GB
hi below is a sample of my code which appears in an asp page...
how can i page the recordset returned to show 10 results on a page?


Set xml = Server.CreateObject ("Microsoft.XMLHTTP")
xml.Open "GET", " & queryStr & "&offset=" & txtOffset , false'
xml.send
resultLength = CInt(xml.selectNodes("SEARCHRESULTS/RESULTSET/RESULT").length)

For iCount= 0 to CInt(resultLength)-1
set Node = xml.selectSingleNode("SEARCHRESULTS/RESULTSET/RESULT[@ID=" & CInt(iCount)& "]")
Response.Write(Node.selectSingleNode("TITLE").text)
Response.Write(&quot;<DD><a onMouseOver=&quot;&quot;window.status='&quot; & Node.selectSingleNode(&quot;URL&quot;).text & &quot;';return true;&quot;&quot;&quot; )
Response.Write(&quot;onMouseOut=&quot;&quot;window.status='';return true;&quot;&quot; href=&quot;&quot;&quot; & Node.selectSingleNode(&quot;REDIR&quot;).text & &quot;&quot;&quot;>&quot;)
Response.Write(Node.selectSingleNode(&quot;URL&quot;).text & &quot;</a></DD><br><br>&quot;)
Next

Set xml = nothing
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top