Solved

Using DRW, need to page forward without button push

Posted on 2004-08-18
3
216 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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

When deciding to adopt any help desk solutions many factors should be explored before taking decisions. This will change from business to another but in general there are some kind of rule of thumb. Here are some quick tips: Do we need only ticket…
This article provides a case study on how our local youth baseball league deployed a new website, including the platform selection, implementation and benefits to the league.
The purpose of this video is to demonstrate how to manually back up a WordPress Database. This will be demonstrated using a Windows 8 PC. The Host used will be IPage.com Log into your Hosting account. IPage will be used for demonstration : Locat…
The purpose of this video is to demonstrate how to Test the speed of a WordPress Website. Site Speed is an important metric of a site’s health. Slow site speed can result in viewers leaving your site quickly and not seeing your content. This…

838 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