Solved

Using DRW, need to page forward without button push

Posted on 2004-08-18
3
215 Views
Last Modified: 2013-12-24
I used DRW to link to SQL.  I have a directory of records that I need to display.  The user can only view the screen (no keyboard or mouse input) so they cannot click on the Next Page button.  Is there a way to display the current records for 10 seconds and then automatically load the next set of records and then when it has reached the end of the records, loop back to the beginning?  The user doesn't have to change any fields, they just need to view the info.  I rated this high because this need to go to production immediately.  Thanks for the help.
0
Comment
Question by:lkoester
  • 2
3 Comments
 
LVL 12

Accepted Solution

by:
rcmb earned 500 total points
ID: 11837269
Okay I cannot quite give you what you have asked for but I do have a work around. Create one page displaying all records.

Then inside the head tags put this code (change trng.asp to your page name):

   <SCRIPT language="JavaScript">
   <!--
   var INTRV;
   var lastSCR=999;
   function scrollpage()
   {
      lastSCR=document.body.scrollTop;
      window.scrollBy(0,1);
      if (document.body.scrollTop == lastSCR)
      {
        clearInterval(INTRV);
        window.location.href="trng.asp"
      }
   }
   //-->
   </SCRIPT>

Change your opening body tag to read:

<BODY onLoad="INTRV=setInterval('scrollpage()',40)">

You can modify the scrollpage value to scroll as fast or as slow as you need.

What this page will do is scroll to the bottom of the page and then return to the top and continue forever.

RCMB
0
 

Author Comment

by:lkoester
ID: 11842901
That's a good idea.  I'll give it a try.  Thanks for the help and the code.  
0
 

Author Comment

by:lkoester
ID: 11846801
Ok, I tried it and it works as advertised.  Is there anyway to pause the scroll after each page of records?  I looked and couldn't find anything.  I might have to move away from the DRW and just code it.

Thanks for the help.
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Objective of This Article In 1990’s, when I was a budding software professional, I had a lot of confusion about which stream or technology, I had to choose to build my career. In those days, I had lot of confusion like whether to choose System so…
This guide will walk you through the essential considerations and tech stack for building scalable websites. Know how to grow your business the smart way!
The purpose of this video is to demonstrate how to exclude a particular blog category from the main blog page. This is can be used when a category already has its own tab, or you simply want certain types of posts not to show up on the main blog. …
The purpose of this video is to demonstrate how to integrate Mailchimp with WordPress, by placing a Mailchimp signup form on a WordPress Page or Post. This will be demonstrated using a Windows 8 PC. Mailchimp will be used. Log into your Mailchi…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now