Solved

Using DRW, need to page forward without button push

Posted on 2004-08-18
3
218 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
HTML Editor That Indents Code As Illustrated 11 144
Ecommerce options and opinions... 6 64
span onclick not working if no string displayed 7 66
Advanced Visual HTML Editor 2 96
In this short web based tutorial, I wanted to show users how they can still use the powers of FrontPage in conjunction with Expression Web 3.  Even though Microsoft eliminated the use of Web components, we can still use them with FrontPage and edit …
Dramatic changes are revolutionizing how we build and use technology. Every company is automating, digitizing, and modernizing operations. We need a better, more connected way to work together as teams so we can harness the insights from our system…
The purpose of this video is to demonstrate how to automatically show related posts at the bottom of a blog post in WordPress. This will be demonstrated using a Windows 8 PC. Plugin “Yet Another Related Posts Plugin” will be used. Go to your…
The purpose of this video is to demonstrate how to make a WordPress Site faster and smaller in size by cleaning up the database. This will be demonstrated using a Windows 8 PC. Plugin WP Optimize will be used. Go to your WordPress login page. T…

732 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