p2p.wrox.com: Archives - asp_web

asp_web_howto thread: Scrolling through a database in access

Message #1 by "Jonathan Marshall" <jdmarsh2g@h...> on Wed, 12 Dec 2001 16:03:25 +0000

<html><div style='background-color:'><DIV>What is the best way to scroll through
records dispaying the information of each record in a form with hyperlinks or buttons<BR></DIV></div><br
clear=all><hr>Get your FREE download of MSN Explorer at <a
href='http://go.msn.com/bql/hmtag_etl_EN.asp'>http://explorer.msn.com</a>.<br></html>

Message #2 by Nick Charlesworth <nick@f...> on Wed, 12 Dec 2001 16:13:08 -0000

This message is in MIME format. Since your mail reader does not understand

this format, some or all of this message may not be legible.



------_=_NextPart_001_01C18327.E6C76538

Content-Type: text/plain;

	charset="iso-8859-1"



Response.Write "<table>"

While Not rs.EOF

    Response.Write "<tr><td>" & rs("strPrice") & "</td><td><a

href=""newpage.asp?ID=" & rs("intID") & """>" & rs("strItemName") &

"</a></td></tr>"

    rs.MoveNext

Wend

Response.Write "</table>"



-----Original Message-----

From: Jonathan Marshall [mailto:jdmarsh2g@h...]

Sent: 12 December 2001 16:03

To: ASP Web HowTo

Subject: [asp_web_howto] Scrolling through a database in access





What is the best way to scroll through records dispaying the information of

each record in a form with hyperlinks or buttons





  _____  



Get your FREE download of MSN Explorer at http://explorer.msn.com

<http://go.msn.com/bql/hmtag_etl_EN.asp> .




$subst('Email.Unsub').

Message #3 by "Jonathan Marshall" <jdmarsh2g@h...> on Wed, 12 Dec 2001 19:07:16 +0000

<html><div style='background-color:'><DIV>

<P>Oh okay. Im not trying to get to another page what i meant was if you have a form and connect to the database. Fill the
form with values from the database. Then from there going on to the next record and so forth being able to scroll back and forth
through recordsets using a button &lt;input type=button value=next_record name=next_record&gt;&nbsp; not sure if i
explained that correctly<BR><BR></P></DIV>

<DIV></DIV>

<DIV></DIV>&gt;From: Nick Charlesworth <NICK@F...>

<DIV></DIV>&gt;Reply-To: "ASP Web HowTo" <ASP_WEB_HOWTO@P...>

<DIV></DIV>&gt;To: "ASP Web HowTo" <ASP_WEB_HOWTO@P...>

<DIV></DIV>&gt;Subject: [asp_web_howto] RE: Scrolling through a database in access 

<DIV></DIV>&gt;Date: Wed, 12 Dec 2001 16:13:08 -0000 

<DIV></DIV>&gt; 

<DIV></DIV>&gt;Response.Write "

<TABLE>" 

<DIV></DIV>&gt;While Not rs.EOF 

<DIV></DIV>&gt; Response.Write "

<TBODY>

<TR>

<TD>" &amp; rs("strPrice") &amp; "</TD>

<TD><A DIV <>&gt;href=""newpage.asp?ID=" &amp; rs("intID") &amp; """&gt;" &amp; rs("strItemName")
&amp; 

<DIV></DIV>&gt;"</A></TD></TR>" 

<DIV></DIV>&gt; rs.MoveNext 

<DIV></DIV>&gt;Wend 

<DIV></DIV>&gt;Response.Write "</TBODY></TABLE>" 

<DIV></DIV>&gt; 

<DIV></DIV>&gt;-----Original Message----- 

<DIV></DIV>&gt;From: Jonathan Marshall [mailto:jdmarsh2g@h...] 

<DIV></DIV>&gt;Sent: 12 December 2001 16:03 

<DIV></DIV>&gt;To: ASP Web HowTo 

<DIV></DIV>&gt;Subject: [asp_web_howto] Scrolling through a database in access 

<DIV></DIV>&gt; 

<DIV></DIV>&gt; 

<DIV></DIV>&gt;What is the best way to scroll through records dispaying the information of 

<DIV></DIV>&gt;each record in a form with hyperlinks or buttons 

<DIV></DIV>&gt; 

<DIV></DIV>&gt; 

<DIV></DIV>&gt; _____ 

<DIV></DIV>&gt; 

<DIV></DIV>&gt;Get your FREE download of MSN Explorer at http://explorer.msn.com 

<DIV></DIV>&gt; . 

<DIV></DIV>&gt;--- 

<DIV></DIV>&gt;

<DIV></DIV>&gt;

<DIV></DIV>&gt;$subst('Email.Unsub'). 

<DIV></DIV>&gt; 

<DIV></DIV>&gt; 

<DIV></DIV>&gt; 

<DIV></DIV>&gt;--- 

<DIV></DIV>&gt;

<DIV></DIV>&gt;

<DIV></DIV></div><br clear=all><hr>MSN Photos is the easiest way to share and print your photos: <a
href='http://go.msn.com/bql/hmtag3_etl_EN.asp'>Click Here</a><br></html>

Message #4 by "Ken Schaefer" <ken@a...> on Thu, 13 Dec 2001 12:13:32 +1100

Have a hidden HTML input field that contains the ID of the next and previous

records. Use that to extract the relevant information for the next/previous

record



This follows the same princple as "paging", where "next/previous page" is

involved. There are plenty of example on the web...



Cheers

Ken



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

From: "Jonathan Marshall" <jdmarsh2g@h...>

Subject: [asp_web_howto] RE: Scrolling through a database in access





: Oh okay. Im not trying to get to another page what i meant was if you have

a form and connect to the database. Fill the form with values from the

database. Then from there going on to the next record and so forth being

able to scroll back and forth through recordsets using a button <input

type=button value=next_record name=next_record>  not sure if i explained

that correctly

:



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Message #5 by "Jonathan Marshall" <jdmarsh2g@h...> on Thu, 13 Dec 2001 01:24:44 +0000

<html><div style='background-color:'><DIV>

<P>What are some good asp sites where i can learn these types of procedures.&nbsp; For paging through records etc....
<BR><BR>thanks again Ken <BR><BR><BR></P></DIV>

<DIV></DIV>

<DIV></DIV>&gt;From: "Ken Schaefer" <KEN@A...>

<DIV></DIV>&gt;Reply-To: "ASP Web HowTo" <ASP_WEB_HOWTO@P...>

<DIV></DIV>&gt;To: "ASP Web HowTo" <ASP_WEB_HOWTO@P...>

<DIV></DIV>&gt;Subject: [asp_web_howto] RE: Scrolling through a database in access 

<DIV></DIV>&gt;Date: Thu, 13 Dec 2001 12:13:32 +1100 

<DIV></DIV>&gt; 

<DIV></DIV>&gt;Have a hidden HTML input field that contains the ID of the next and previous 

<DIV></DIV>&gt;records. Use that to extract the relevant information for the next/previous 

<DIV></DIV>&gt;record 

<DIV></DIV>&gt; 

<DIV></DIV>&gt;This follows the same princple as "paging", where "next/previous page" is 

<DIV></DIV>&gt;involved. There are plenty of example on the web... 

<DIV></DIV>&gt; 

<DIV></DIV>&gt;Cheers 

<DIV></DIV>&gt;Ken 

<DIV></DIV>&gt; 

<DIV></DIV>&gt;~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 

<DIV></DIV>&gt;From: "Jonathan Marshall" <JDMARSH2G@H...>

<DIV></DIV>&gt;Subject: [asp_web_howto] RE: Scrolling through a database in access 

<DIV></DIV>&gt; 

<DIV></DIV>&gt; 

<DIV></DIV>&gt;: Oh okay. Im not trying to get to another page what i meant was if you have 

<DIV></DIV>&gt;a form and connect to the database. Fill the form with values from the 

<DIV></DIV>&gt;database. Then from there going on to the next record and so forth being 

<DIV></DIV>&gt;able to scroll back and forth through recordsets using a button <INPUT DIV
<>&gt;type=button value=next_record name=next_record&gt; not sure if i explained 

<DIV></DIV>&gt;that correctly 

<DIV></DIV>&gt;: 

<DIV></DIV>&gt; 

<DIV></DIV>&gt;~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 

<DIV></DIV>&gt; 

<DIV></DIV>&gt; 

<DIV></DIV>&gt;--- 

<DIV></DIV>&gt;

<DIV></DIV>&gt;

<DIV></DIV></div><br clear=all><hr>Join the world?s largest e-mail service with MSN Hotmail. <a
href='http://go.msn.com/bql/hmtag4_etl_EN.asp'>Click Here</a><br></html>

Message #6 by "Ken Schaefer" <ken@a...> on Thu, 13 Dec 2001 14:23:01 +1100

If you want the fastest way that I've been able to find using Access:

www.adopenstatic.com/experiments/recordsetpaging.asp - use the methodology

that uses an adOpenForwardOnly cursor & .GetRows(), but without the stored

procedure (you will need to use an inline SQL statement). This is probably

not an approach for beginners though, as you will need to code some of the

functionality that ADO provides intrinsically (though at a performance

penalty).



The "generic", or "standard" way to do paging can be found in many places:

http://www.google.com/search?q=paging+a+recordset+with+ASP

Almost all the links on the first page of results will tell you what you

need



Cheers

Ken



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

From: "Jonathan Marshall" <jdmarsh2g@h...>

Subject: [asp_web_howto] RE: Scrolling through a database in access





: What are some good asp sites where i can learn these types of procedures.

For paging through records etc....

:

: thanks again Ken



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Message #7 by "Jonathan Marshall" <jdmarsh2g@h...> on Thu, 13 Dec 2001 03:59:36 +0000

<html><div style='background-color:'><DIV>

<P>thanks a lot ken much appreciated and tons to learn<BR><BR></P></DIV>

<DIV></DIV>

<DIV></DIV>&gt;From: "Ken Schaefer" <KEN@A...>

<DIV></DIV>&gt;Reply-To: "ASP Web HowTo" <ASP_WEB_HOWTO@P...>

<DIV></DIV>&gt;To: "ASP Web HowTo" <ASP_WEB_HOWTO@P...>

<DIV></DIV>&gt;Subject: [asp_web_howto] RE: Scrolling through a database in access 

<DIV></DIV>&gt;Date: Thu, 13 Dec 2001 14:23:01 +1100 

<DIV></DIV>&gt; 

<DIV></DIV>&gt;If you want the fastest way that I've been able to find using Access: 

<DIV></DIV>&gt;www.adopenstatic.com/experiments/recordsetpaging.asp - use the methodology 

<DIV></DIV>&gt;that uses an adOpenForwardOnly cursor &amp; .GetRows(), but without the stored 

<DIV></DIV>&gt;procedure (you will need to use an inline SQL statement). This is probably 

<DIV></DIV>&gt;not an approach for beginners though, as you will need to code some of the 

<DIV></DIV>&gt;functionality that ADO provides intrinsically (though at a performance 

<DIV></DIV>&gt;penalty). 

<DIV></DIV>&gt; 

<DIV></DIV>&gt;The "generic", or "standard" way to do paging can be found in many places: 

<DIV></DIV>&gt;http://www.google.com/search?q=paging+a+recordset+with+ASP 

<DIV></DIV>&gt;Almost all the links on the first page of results will tell you what you 

<DIV></DIV>&gt;need 

<DIV></DIV>&gt; 

<DIV></DIV>&gt;Cheers 

<DIV></DIV>&gt;Ken 

<DIV></DIV>&gt; 

<DIV></DIV>&gt;~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 

<DIV></DIV>&gt;From: "Jonathan Marshall" <JDMARSH2G@H...>

<DIV></DIV>&gt;Subject: [asp_web_howto] RE: Scrolling through a database in access 

<DIV></DIV>&gt; 

<DIV></DIV>&gt; 

<DIV></DIV>&gt;: What are some good asp sites where i can learn these types of procedures. 

<DIV></DIV>&gt;For paging through records etc.... 

<DIV></DIV>&gt;: 

<DIV></DIV>&gt;: thanks again Ken 

<DIV></DIV>&gt; 

<DIV></DIV>&gt;~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 

<DIV></DIV>&gt; 

<DIV></DIV>&gt; 

<DIV></DIV>&gt;--- 

<DIV></DIV>&gt;

<DIV></DIV>&gt;

<DIV></DIV></div><br clear=all><hr>Send and receive Hotmail on your mobile device: <a
href='http://go.msn.com/bql/hmtag2_etl_EN.asp'>Click Here</a><br></html>

Return to Index

P2P Archives