• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 227
  • Last Modified:

Using DRW, need to page forward without button push

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
lkoester
Asked:
lkoester
  • 2
1 Solution
 
rcmbCommented:
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
 
lkoesterAuthor Commented:
That's a good idea.  I'll give it a try.  Thanks for the help and the code.  
0
 
lkoesterAuthor Commented:
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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now