Wrox Programmer Forums
|
Classic ASP Basics For beginner programmers starting with "classic" ASP 3, pre-".NET." NOT for ASP.NET 1.0, 1.1, or 2.0
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Page 1 of 2 1 2
 
Old April 1st, 2004, 01:18 AM
Authorized User
  
Join Date: Apr 2004
Posts: 31
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to pigtail Send a message via Yahoo to pigtail
Default Refresh a page without the flickering effect
I have written an ASP to retrieve data from the databases and presented it in a table format. I refresh this page every 5 seconds to retrieve new data. Every 5 seconds, my page flickers as it refreshes. It's very annoying, especially if I am checking out the data 80 rows below the top of the page. The refresh takes me right back to the top of the page. Does anyone know how to refresh the table without this flickering effect?
 
Old April 1st, 2004, 03:38 AM
Imar's Avatar
Wrox Author
  
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default
Hi there

Take a look here: http://www.glendinning.org/webbuilde...ripJavaScript/ and here: http://www.glendinning.org/webbuilder/roundTripIframe/

These pages may give you some ideas how to accomplish this.

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
 
Old April 2nd, 2004, 12:52 AM
Authorized User
  
Join Date: Apr 2004
Posts: 31
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to pigtail Send a message via Yahoo to pigtail
Default
Thanks for sharing your code.

I am using <META HTTP-EQUIV="REFRESH" Content="5;URL=trafficmonitor.asp"> to refresh my ASP page every 5 seconds. During each refresh, I bring back new database values to my table. Do I have to convert my ASP to JavaScript? If not, I think the page will still flicker when it refreshes itself every 5 seconds. Any idea?
 
Old April 2nd, 2004, 02:50 AM
Imar's Avatar
Wrox Author
  
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default
I am not quite sure I understand.
The two links I showed you explain you how to retrieve new data from the server, with a bit of client side JavaScript, to avoid the flickering.

Can't you use the suggestions from these two links? Why are you still using a meta refresh?

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
 
Old April 2nd, 2004, 09:55 PM
Authorized User
  
Join Date: Apr 2004
Posts: 31
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to pigtail Send a message via Yahoo to pigtail
Default
I have learned so much today. I didn't realize that I could have my ASP server code intermix with my client-side JavaScript. So, that was great. However, I still run into one problem.

I tried using DOM to control my table data and ran into a problem. Toward the end of the code below, I don't know how to clear out my document object so that it will have the new data saved in oTableContainer each time it calls the updatetable function.

Also, the use of setTimeout will cause a new thread to be created. Will the old threads be cleaned up on the server automatically? If not, how do I clean up the old threads so that the thread counts on the server won't keep going up?

If I want to execute some database clean up tasks when the browser is closed, what Javascript event should I use?

<html>
<head>
</head>
<body>
<center>

<DIV ID="oTableContainer"></DIV>

<SCRIPT LANGUAGE="JavaScript">

function updatetable()
{
var oTable = document.createElement("TABLE");
var oTHead0 = document.createElement("THEAD");
var oTBody0 = document.createElement("TBODY");

// Declare Headings.
var heading0 = new Array;
heading0[0] = "Service Class/Queue ID";

// Insert the created elements into oTable.
oTable.appendChild(oHeading0);
oTable.appendChild(oTHead0);
oTable.appendChild(oTBody0);

// Insert the table into the document tree.
var txt = "My Heading";
newtext = document.createTextNode(txt);
oHeading0.appendChild(newtext);
document.body.appendChild(oHeading0);

// Insert a row into the header
oRow = document.createElement("TR");
oTHead0.appendChild(oRow);

// Create and insert cells into the header
for (i=0; i<5; i++)
{
  oCell = document.createElement("TH");
  oCell.innerText = heading0[i];
  oRow.appendChild(oCell);
}
<%
My ASP code goes here to read a row from the database, populate the Session variables that are used below
%>
// Create and insert rows and cells into the first body.
  oRow = document.createElement("TR");
  oTBody0.appendChild(oRow);

    oCell = document.createElement("TD");
    oCell.innerText = '<%=Session("svcname")%>';

<%
Loop back to read the next row from the database
%>

oTableContainer.innerText = '';

//MY PROBLEM IS HERE. IT KEEPS ON DISPLAYING THE SAME DATA IN THE BROWSER.
oTableContainer.appendChild(oHeading0);
oTableContainer.appendChild(oHeading1);
oTableContainer.appendChild(oHeading2);
oTableContainer.appendChild(oTable);

setTimeout("updatetable()", 1000);
}
updatetable();
</SCRIPT>
</body>
</html>
 
Old April 3rd, 2004, 05:08 AM
Imar's Avatar
Wrox Author
  
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default
Well, you can mix the two to some extend, but from what I can see, what you're trying to do will not work.

When the page first loads, the ASP code in the <% and %> block will run, and send some output to the client.

When the updatetable function runs in client side JavaScript, the server side block does no longer execute. Look in the HTML source for the browser, and you'll see there is no server side code block anymore. So, the updatetable function will just use the output from the first server execution of the page.

To get dynamic new stuff from the server, you'll have to use the tricks I pointed you to with the two links I posted earlier. This way, you can have the server part execute in another "page" (hidden, in another frame or JavaScript file) and read from that file to update your visible page.

Does this help?

Imar

---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
 
Old April 3rd, 2004, 07:08 PM
Authorized User
  
Join Date: Apr 2004
Posts: 31
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to pigtail Send a message via Yahoo to pigtail
Default
YES! Your code is extremely help! Thanks for your help!!

Now, my new problem is my IE6 ran into some kind of exception. If I have 7 rows returned in the table, it will refresh perfectly for a few minutes. If I have 4, 5 or 6 rows returned in a browser, it will refresh without crashing. If I have 12 rows, the browser dies much sooner. I wasn't out of any resources on the server and the client. I wonder why??

Here is the code for reading data from the database:
<html>
<head>
<title>Untitled</title>
<script language="JavaScript" type="text/javascript">
<!--
function HiMom() {

    var reply = new Array;
    var ind = 0;
<% read a database row and assign their values to the five Session variables.%>
    reply[ind] = new Array('<%=Session("fld1")%>', <%=Session("fld2")%>, <%=Session("fld3")%>, <%=Session("fld4")%>, <%=Session("fld5")%>);
    ind = ind + 1;
<% loop to get the next Database row. When done, close all database connections. %>
    window.parent.ReceiveData(reply);
}

onload = HiMom;
//-->
</script>
</head>
<body></body>
</html>

Here is my client-side script:
<html>
<head>

<style type="text/css">
<!--
#oTableContainer { position: absolute; visibility: hidden; }
-->
</style>
<script language="JavaScript" type="text/javascript">
<!--
function GetTable() {
    var oTableContainer = document.getElementById('oTableContainer');
    oTableContainer.src = "dataread.asp";
    timerID = setTimeout("GetTable()", 10000);
}

function ReceiveData(response)
{

    var table = document.getElementById('results');
    var oldTbody = table.getElementsByTagName('tbody')[0];
    var newTbody = document.createElement('tbody');
    table.replaceChild(newTbody, oldTbody);

    var table = document.getElementById('results');
    var oldTbody = table.getElementsByTagName('tbody')[0];
    var newTbody = document.createElement('tbody');
    table.replaceChild(newTbody, oldTbody);
    for (var i=0, istop=response.length; i<istop; i++) {
        var tempRow = document.createElement('tr');
        for (var j=0, jstop=response[i].length; j<jstop; j++) {
            var tempCell = document.createElement('td');
            var tempText = document.createTextNode(response[i][j]);
            tempCell.appendChild(tempText);
            tempRow.appendChild(tempCell);
        }
        newTbody.appendChild(tempRow);
    }

}
//-->
</script>
</head>
<body>
<center>
<H3 id="h3">
</H3>
<table id="results" border="1">
<thead>
</thead>
<tbody>
</tbody>
</table>

<iframe src="blank.html" name="oTableContainer" id="oTableContainer"></iframe>
</center>

<script type="text/javascript" language="JavaScript">
<!--
   var lStart = 0;
   var lEnd = 1;

   for (lStart = 0; lStart < lEnd; lStart++)
   {
      GetTable();
    }


//-->
</script>

</body>
</html>

The error log generated by the IE browser is below:
<?xml version="1.0" encoding="UTF-16"?>
<DATABASE>
<EXE NAME="iexplore.exe" FILTER="GRABMI_FILTER_PRIVACY">
    <MATCHING_FILE NAME="hmmapi.dll" SIZE="36352" CHECKSUM="0x8DE5BA15" BIN_FILE_VERSION="6.0.2800.1106" BIN_PRODUCT_VERSION="6.0.2800.1106" PRODUCT_VERSION="6.00.2800.1106" FILE_DESCRIPTION="Microsoft HTTP Mail Simple MAPI" COMPANY_NAME="Microsoft Corporation" PRODUCT_NAME="Microsoft® Windows® Operating System" FILE_VERSION="6.00.2800.1106 (xpsp1.020828-1920)" ORIGINAL_FILENAME="HMMAPI.DLL" INTERNAL_NAME="HMMAPI" LEGAL_COPYRIGHT="© Microsoft Corporation. All rights reserved." VERFILEDATEHI="0x0" VERFILEDATELO="0x0" VERFILEOS="0x40004" VERFILETYPE="0x2" MODULE_TYPE="WIN32" PE_CHECKSUM="0x17AF5" LINKER_VERSION="0x50001" UPTO_BIN_FILE_VERSION="6.0.2800.1106" UPTO_BIN_PRODUCT_VERSION="6.0.2800.1106" LINK_DATE="08/29/2002 10:39:53" UPTO_LINK_DATE="08/29/2002 10:39:53" VER_LANGUAGE="English (United States) [0x409]" />
    <MATCHING_FILE NAME="iexplore.exe" SIZE="91136" CHECKSUM="0x678704C6" BIN_FILE_VERSION="6.0.2800.1106" BIN_PRODUCT_VERSION="6.0.2800.1106" PRODUCT_VERSION="6.00.2800.1106" FILE_DESCRIPTION="Internet Explorer" COMPANY_NAME="Microsoft Corporation" PRODUCT_NAME="Microsoft® Windows® Operating System" FILE_VERSION="6.00.2800.1106 (xpsp1.020828-1920)" ORIGINAL_FILENAME="IEXPLORE.EXE" INTERNAL_NAME="iexplore" LEGAL_COPYRIGHT="© Microsoft Corporation. All rights reserved." VERFILEDATEHI="0x0" VERFILEDATELO="0x0" VERFILEOS="0x40004" VERFILETYPE="0x1" MODULE_TYPE="WIN32" PE_CHECKSUM="0x18E86" LINKER_VERSION="0x50001" UPTO_BIN_FILE_VERSION="6.0.2800.1106" UPTO_BIN_PRODUCT_VERSION="6.0.2800.1106" LINK_DATE="08/29/2002 08:22:25" UPTO_LINK_DATE="08/29/2002 08:22:25" VER_LANGUAGE="English (United States) [0x409]" />
    <MATCHING_FILE NAME="Connection Wizard\icwconn.dll" SIZE="57344" CHECKSUM="0x20CCE0F1" BIN_FILE_VERSION="6.0.2600.0" BIN_PRODUCT_VERSION="6.0.2600.0" PRODUCT_VERSION="6.00.2600.0000" FILE_DESCRIPTION="Internet Connection Wizard" COMPANY_NAME="Microsoft Corporation" PRODUCT_NAME="Microsoft® Windows® Operating System" FILE_VERSION="6.00.2600.0000 (xpclient.010817-1148)" ORIGINAL_FILENAME="icwconn.dll" INTERNAL_NAME="icwconn" LEGAL_COPYRIGHT="© Microsoft Corporation. All rights reserved." VERFILEDATEHI="0x0" VERFILEDATELO="0x0" VERFILEOS="0x40004" VERFILETYPE="0x1" MODULE_TYPE="WIN32" PE_CHECKSUM="0x1C571" LINKER_VERSION="0x50001" UPTO_BIN_FILE_VERSION="6.0.2600.0" UPTO_BIN_PRODUCT_VERSION="6.0.2600.0" LINK_DATE="08/18/2001 05:35:00" UPTO_LINK_DATE="08/18/2001 05:35:00" VER_LANGUAGE="English (United States) [0x409]" />
    <MATCHING_FILE NAME="Connection Wizard\icwconn1.exe" SIZE="208896" CHECKSUM="0x3ABA8DDB" BIN_FILE_VERSION="6.0.2800.1106" BIN_PRODUCT_VERSION="6.0.2800.1106" PRODUCT_VERSION="6.00.2800.1106" FILE_DESCRIPTION="Internet Connection Wizard" COMPANY_NAME="Microsoft Corporation" PRODUCT_NAME="Microsoft® Windows® Operating System" FILE_VERSION="6.00.2800.1106 (xpsp1.020828-1920)" ORIGINAL_FILENAME="icwconn1.exe" INTERNAL_NAME="icwconn1" LEGAL_COPYRIGHT="© Microsoft Corporation. All rights reserved." VERFILEDATEHI="0x0" VERFILEDATELO="0x0" VERFILEOS="0x40004" VERFILETYPE="0x1" MODULE_TYPE="WIN32" PE_CHECKSUM="0x40D69" LINKER_VERSION="0x50001" UPTO_BIN_FILE_VERSION="6.0.2800.1106" UPTO_BIN_PRODUCT_VERSION="6.0.2800.1106" LINK_DATE="08/29/2002 08:25:04" UPTO_LINK_DATE="08/29/2002 08:25:04" VER_LANGUAGE="English (United States) [0x409]" />
    <MATCHING_FILE NAME="Connection Wizard\icwconn2.exe" SIZE="77824" CHECKSUM="0x4BF0261D" BIN_FILE_VERSION="6.0.2600.0" BIN_PRODUCT_VERSION="6.0.2600.0" PRODUCT_VERSION="6.00.2600.0000" FILE_DESCRIPTION="Internet Connection Wizard" COMPANY_NAME="Microsoft Corporation" PRODUCT_NAME="Microsoft® Windows® Operating System" FILE_VERSION="6.00.2600.0000 (xpclient.010817-1148)" ORIGINAL_FILENAME="ICWCONN2.EXE" INTERNAL_NAME="ICWCONN2" LEGAL_COPYRIGHT="© Microsoft Corporation. All rights reserved." VERFILEDATEHI="0x0" VERFILEDATELO="0x0" VERFILEOS="0x40004" VERFILETYPE="0x1" MODULE_TYPE="WIN32" PE_CHECKSUM="0x1A815" LINKER_VERSION="0x50001" UPTO_BIN_FILE_VERSION="6.0.2600.0" UPTO_BIN_PRODUCT_VERSION="6.0.2600.0" LINK_DATE="08/17/2001 20:49:06" UPTO_LINK_DATE="08/17/2001 20:49:06" VER_LANGUAGE="English (United States) [0x409]" />
    <MATCHING_FILE NAME="Connection Wizard\icwdl.dll" SIZE="24576" CHECKSUM="0x30C34852" BIN_FILE_VERSION="6.0.2600.0" BIN_PRODUCT_VERSION="6.0.2600.0" PRODUCT_VERSION="6.00.2600.0000" FILE_DESCRIPTION="Internet Service MIME Mutlipart Download" COMPANY_NAME="Microsoft Corporation" PRODUCT_NAME="Microsoft® Windows® Operating System" FILE_VERSION="6.00.2600.0000 (xpclient.010817-1148)" ORIGINAL_FILENAME="ICWDL.DLL" INTERNAL_NAME="ICWDL" LEGAL_COPYRIGHT="© Microsoft Corporation. All rights reserved." VERFILEDATEHI="0x0" VERFILEDATELO="0x0" VERFILEOS="0x40004" VERFILETYPE="0x2" MODULE_TYPE="WIN32" PE_CHECKSUM="0x140B3" LINKER_VERSION="0x50001" UPTO_BIN_FILE_VERSION="6.0.2600.0" UPTO_BIN_PRODUCT_VERSION="6.0.2600.0" LINK_DATE="08/18/2001 05:35:02" UPTO_LINK_DATE="08/18/2001 05:35:02" VER_LANGUAGE="English (United States) [0x409]" />
    <MATCHING_FILE NAME="Connection Wizard\icwhelp.dll" SIZE="155648" CHECKSUM="0xD9B3825A" BIN_FILE_VERSION="6.0.2600.0" BIN_PRODUCT_VERSION="6.0.2600.0" PRODUCT_VERSION="6.00.2600.0000" FILE_DESCRIPTION="Internet Connection Wizard Helper functions" COMPANY_NAME="Microsoft Corporation" PRODUCT_NAME="Microsoft® Windows® Operating System" FILE_VERSION="6.00.2600.0000 (xpclient.010817-1148)" ORIGINAL_FILENAME="icwhelp.dll" INTERNAL_NAME="icwhelp" LEGAL_COPYRIGHT="© Microsoft Corporation. All rights reserved." VERFILEDATEHI="0x0" VERFILEDATELO="0x0" VERFILEOS="0x40004" VERFILETYPE="0x1" MODULE_TYPE="WIN32" PE_CHECKSUM="0x26C09" LINKER_VERSION="0x50001" UPTO_BIN_FILE_VERSION="6.0.2600.0" UPTO_BIN_PRODUCT_VERSION="6.0.2600.0" LINK_DATE="08/18/2001 05:35:03" UPTO_LINK_DATE="08/18/2001 05:35:03" VER_LANGUAGE="English (United States) [0x409]" />
    <MATCHING_FILE NAME="Connection Wizard\icwres.dll" SIZE="61440" CHECKSUM="0xA488AA92" BIN_FILE_VERSION="6.0.2600.0" BIN_PRODUCT_VERSION="6.0.2600.0" PRODUCT_VERSION="6.00.2600.0000" FILE_DESCRIPTION="Internet Connection Wizard" COMPANY_NAME="Microsoft Corporation" PRODUCT_NAME="Microsoft® Windows® Operating System" FILE_VERSION="6.00.2600.0000 (xpclient.010817-1148)" ORIGINAL_FILENAME="icwres.dll" INTERNAL_NAME="icwres" LEGAL_COPYRIGHT="© Microsoft Corporation. All rights reserved." VERFILEDATEHI="0x0" VERFILEDATELO="0x0" VERFILEOS="0x40004" VERFILETYPE="0x1" MODULE_TYPE="WIN32" PE_CHECKSUM="0x1AA60" LINKER_VERSION="0x50001" UPTO_BIN_FILE_VERSION="6.0.2600.0" UPTO_BIN_PRODUCT_VERSION="6.0.2600.0" LINK_DATE="08/18/2001 05:35:05" UPTO_LINK_DATE="08/18/2001 05:35:05" VER_LANGUAGE="English (United States) [0x409]" />
    <MATCHING_FILE NAME="Connection Wizard\icwrmind.exe" SIZE="24576" CHECKSUM="0xC9FC9939" BIN_FILE_VERSION="6.0.2600.0" BIN_PRODUCT_VERSION="6.0.2600.0" PRODUCT_VERSION="6.00.2600.0000" FILE_DESCRIPTION="Internet Connection Wizard Reminder" COMPANY_NAME="Microsoft Corporation" PRODUCT_NAME="Microsoft® Windows® Operating System" FILE_VERSION="6.00.2600.0000 (xpclient.010817-1148)" ORIGINAL_FILENAME="ICWRMIND.EXE" INTERNAL_NAME="ICWRMIND" LEGAL_COPYRIGHT="© Microsoft Corporation. All rights reserved." VERFILEDATEHI="0x0" VERFILEDATELO="0x0" VERFILEOS="0x40004" VERFILETYPE="0x1" MODULE_TYPE="WIN32" PE_CHECKSUM="0xEF6D" LINKER_VERSION="0x50001" UPTO_BIN_FILE_VERSION="6.0.2600.0" UPTO_BIN_PRODUCT_VERSION="6.0.2600.0" LINK_DATE="08/17/2001 20:48:19" UPTO_LINK_DATE="08/17/2001 20:48:19" VER_LANGUAGE="English (United States) [0x409]" />
    <MATCHING_FILE NAME="Connection Wizard\icwtutor.exe" SIZE="73728" CHECKSUM="0xF945F7EB" BIN_FILE_VERSION="6.0.2600.0" BIN_PRODUCT_VERSION="6.0.2600.0" PRODUCT_VERSION="6.00.2600.0000" FILE_DESCRIPTION="Internet Connection Wizard" COMPANY_NAME="Microsoft Corporation" PRODUCT_NAME="Microsoft® Windows® Operating System" FILE_VERSION="6.00.2600.0000 (xpclient.010817-1148)" ORIGINAL_FILENAME="icwtutor.exe" INTERNAL_NAME="icwtutor" LEGAL_COPYRIGHT="© Microsoft Corporation. All rights reserved." VERFILEDATEHI="0x0" VERFILEDATELO="0x0" VERFILEOS="0x40004" VERFILETYPE="0x1" MODULE_TYPE="WIN32" PE_CHECKSUM="0x16B27" LINKER_VERSION="0x50001" UPTO_BIN_FILE_VERSION="6.0.2600.0" UPTO_BIN_PRODUCT_VERSION="6.0.2600.0" LINK_DATE="08/17/2001 20:49:08" UPTO_LINK_DATE="08/17/2001 20:49:08" VER_LANGUAGE="English (United States) [0x409]" />
    <MATCHING_FILE NAME="Connection Wizard\icwutil.dll" SIZE="45056" CHECKSUM="0xE48F22C8" BIN_FILE_VERSION="6.0.2600.0" BIN_PRODUCT_VERSION="6.0.2600.0" PRODUCT_VERSION="6.00.2600.0000" FILE_DESCRIPTION="Internet Connection Wizard" COMPANY_NAME="Microsoft Corporation" PRODUCT_NAME="Microsoft® Windows® Operating System" FILE_VERSION="6.00.2600.0000 (xpclient.010817-1148)" ORIGINAL_FILENAME="icwutil.dll" INTERNAL_NAME="icwutil" LEGAL_COPYRIGHT="© Microsoft Corporation. All rights reserved." VERFILEDATEHI="0x0" VERFILEDATELO="0x0" VERFILEOS="0x40004" VERFILETYPE="0x1" MODULE_TYPE="WIN32" PE_CHECKSUM="0x12C82" LINKER_VERSION="0x50001" UPTO_BIN_FILE_VERSION="6.0.2600.0" UPTO_BIN_PRODUCT_VERSION="6.0.2600.0" LINK_DATE="08/18/2001 05:35:06" UPTO_LINK_DATE="08/18/2001 05:35:06" VER_LANGUAGE="English (United States) [0x409]" />
    <MATCHING_FILE NAME="Connection Wizard\inetwiz.exe" SIZE="20480" CHECKSUM="0x8E84A1F3" BIN_FILE_VERSION="6.0.2600.0" BIN_PRODUCT_VERSION="6.0.2600.0" PRODUCT_VERSION="6.00.2600.0000" FILE_DESCRIPTION="Internet Connection Wizard" COMPANY_NAME="Microsoft Corporation" PRODUCT_NAME="Microsoft® Windows® Operating System" FILE_VERSION="6.00.2600.0000 (xpclient.010817-1148)" ORIGINAL_FILENAME="INETWIZ.EXE" INTERNAL_NAME="INETWIZ" LEGAL_COPYRIGHT="© Microsoft Corporation. All rights reserved." VERFILEDATEHI="0x0" VERFILEDATELO="0x0" VERFILEOS="0x40004" VERFILETYPE="0x1" MODULE_TYPE="WIN32" PE_CHECKSUM="0xED78" LINKER_VERSION="0x50001" UPTO_BIN_FILE_VERSION="6.0.2600.0" UPTO_BIN_PRODUCT_VERSION="6.0.2600.0" LINK_DATE="08/17/2001 20:49:10" UPTO_LINK_DATE="08/17/2001 20:49:10" VER_LANGUAGE="English (United States) [0x409]" />
    <MATCHING_FILE NAME="Connection Wizard\isignup.exe" SIZE="16384" CHECKSUM="0xF8AB8D6E" BIN_FILE_VERSION="6.0.2600.0" BIN_PRODUCT_VERSION="6.0.2600.0" PRODUCT_VERSION="6.00.2600.0000" FILE_DESCRIPTION="Internet Signup" COMPANY_NAME="Microsoft Corporation" PRODUCT_NAME="Microsoft® Windows® Operating System" FILE_VERSION="6.00.2600.0000 (xpclient.010817-1148)" ORIGINAL_FILENAME="ISIGNUP.EXE" INTERNAL_NAME="ISIGNUP" LEGAL_COPYRIGHT="© Microsoft Corporation. All rights reserved." VERFILEDATEHI="0x0" VERFILEDATELO="0x0" VERFILEOS="0x40004" VERFILETYPE="0x1" MODULE_TYPE="WIN32" PE_CHECKSUM="0x443C" LINKER_VERSION="0x50001" UPTO_BIN_FILE_VERSION="6.0.2600.0" UPTO_BIN_PRODUCT_VERSION="6.0.2600.0" LINK_DATE="08/17/2001 20:48:46" UPTO_LINK_DATE="08/17/2001 20:48:46" VER_LANGUAGE="English (United States) [0x409]" />
    <MATCHING_FILE NAME="Connection Wizard\trialoc.dll" SIZE="40960" CHECKSUM="0x68F70073" BIN_FILE_VERSION="6.0.2600.0" BIN_PRODUCT_VERSION="6.0.2600.0" PRODUCT_VERSION="6.00.2600.0000" FILE_DESCRIPTION="Internet Connection Wizard Trial Reminder Helper" COMPANY_NAME="Microsoft Corporation" PRODUCT_NAME="Microsoft® Windows® Operating System" FILE_VERSION="6.00.2600.0000 (xpclient.010817-1148)" ORIGINAL_FILENAME="trialoc.dll" INTERNAL_NAME="trialoc" LEGAL_COPYRIGHT="© Microsoft Corporation. All rights reserved." VERFILEDATEHI="0x0" VERFILEDATELO="0x0" VERFILEOS="0x40004" VERFILETYPE="0x1" MODULE_TYPE="WIN32" PE_CHECKSUM="0x198FE" LINKER_VERSION="0x50001" UPTO_BIN_FILE_VERSION="6.0.2600.0" UPTO_BIN_PRODUCT_VERSION="6.0.2600.0" LINK_DATE="08/18/2001 05:36:03" UPTO_LINK_DATE="08/18/2001 05:36:03" VER_LANGUAGE="English (United States) [0x409]" />
    <MATCHING_FILE NAME="MUI\0409\mscorier.dll" SIZE="16896" CHECKSUM="0xCA915362" BIN_FILE_VERSION="1.1.4322.573" BIN_PRODUCT_VERSION="1.1.4322.573" PRODUCT_VERSION="1.1.4322.573" FILE_DESCRIPTION="Microsoft .NET Runtime IE resources" COMPANY_NAME="Microsoft Corporation" PRODUCT_NAME="Microsoft .NET Framework" FILE_VERSION="1.1.4322.573" ORIGINAL_FILENAME="mscorier.dll" INTERNAL_NAME="MSCORIER.DLL" LEGAL_COPYRIGHT="Copyright © Microsoft Corporation 1998-2002. All rights reserved." VERFILEDATEHI="0x0" VERFILEDATELO="0x0" VERFILEOS="0x4" VERFILETYPE="0x2" MODULE_TYPE="WIN32" PE_CHECKSUM="0x1388C" LINKER_VERSION="0x50000" UPTO_BIN_FILE_VERSION="1.1.4322.573" UPTO_BIN_PRODUCT_VERSION="1.1.4322.573" LINK_DATE="02/21/2003 02:43:37" UPTO_LINK_DATE="02/21/2003 02:43:37" VER_LANGUAGE="English (United States) [0x409]" />
    <MATCHING_FILE NAME="PLUGINS\nppdf32.dll" SIZE="133376" CHECKSUM="0x4906ED95" BIN_FILE_VERSION="6.0.0.878" BIN_PRODUCT_VERSION="6.0.0.878" PRODUCT_VERSION="6.0.0.2003051500" FILE_DESCRIPTION="Adobe Acrobat Plug-In Version 6.00 for Netscape" COMPANY_NAME="Adobe Systems Inc." PRODUCT_NAME="Adobe Acrobat" FILE_VERSION="6.0.0.2003051500" ORIGINAL_FILENAME="NPPDF32.DLL" LEGAL_COPYRIGHT="Copyright 1984-2003 Adobe Systems Incorporated and its licensors. All rights reserved." VERFILEDATEHI="0x0" VERFILEDATELO="0x0" VERFILEOS="0x10001" VERFILETYPE="0x2" MODULE_TYPE="WIN32" PE_CHECKSUM="0x28D49" LINKER_VERSION="0x0" UPTO_BIN_FILE_VERSION="6.0.0.878" UPTO_BIN_PRODUCT_VERSION="6.0.0.878" LINK_DATE="05/15/2003 08:01:47" UPTO_LINK_DATE="05/15/2003 08:01:47" VER_LANGUAGE="English (United States) [0x409]" />
</EXE>
<EXE NAME="mshtml.dll" FILTER="GRABMI_FILTER_THISFILEONLY">
    <MATCHING_FILE NAME="MSHTML.DLL" SIZE="2799104" CHECKSUM="0x6B274407" BIN_FILE_VERSION="6.0.2800.1276" BIN_PRODUCT_VERSION="6.0.2800.1276" PRODUCT_VERSION="6.00.2800.1276" FILE_DESCRIPTION="Microsoft (R) HTML Viewer" COMPANY_NAME="Microsoft Corporation" PRODUCT_NAME="Microsoft® Windows® Operating System" FILE_VERSION="6.00.2800.1276" ORIGINAL_FILENAME="MSHTML.DLL" INTERNAL_NAME="MSHTML" LEGAL_COPYRIGHT="© Microsoft Corporation. All rights reserved." VERFILEDATEHI="0x0" VERFILEDATELO="0x0" VERFILEOS="0x40004" VERFILETYPE="0x2" MODULE_TYPE="WIN32" PE_CHECKSUM="0x2B8803" LINKER_VERSION="0x50001" UPTO_BIN_FILE_VERSION="6.0.2800.1276" UPTO_BIN_PRODUCT_VERSION="6.0.2800.1276" LINK_DATE="10/16/2003 20:34:17" UPTO_LINK_DATE="10/16/2003 20:34:17" VER_LANGUAGE="English (United States) [0x409]" />
</EXE>
<EXE NAME="kernel32.dll" FILTER="GRABMI_FILTER_THISFILEONLY">
    <MATCHING_FILE NAME="kernel32.dll" SIZE="930304" CHECKSUM="0xCBCCF8A9" BIN_FILE_VERSION="5.1.2600.1106" BIN_PRODUCT_VERSION="5.1.2600.1106" PRODUCT_VERSION="5.1.2600.1106" FILE_DESCRIPTION="Windows NT BASE API Client DLL" COMPANY_NAME="Microsoft Corporation" PRODUCT_NAME="Microsoft® Windows® Operating System" FILE_VERSION="5.1.2600.1106 (xpsp1.020828-1920)" ORIGINAL_FILENAME="kernel32" INTERNAL_NAME="kernel32" LEGAL_COPYRIGHT="© Microsoft Corporation. All rights reserved." VERFILEDATEHI="0x0" VERFILEDATELO="0x0" VERFILEOS="0x40004" VERFILETYPE="0x2" MODULE_TYPE="WIN32" PE_CHECKSUM="0xE7ED3" LINKER_VERSION="0x50001" UPTO_BIN_FILE_VERSION="5.1.2600.1106" UPTO_BIN_PRODUCT_VERSION="5.1.2600.1106" LINK_DATE="08/29/2002 10:40:40" UPTO_LINK_DATE="08/29/2002 10:40:40" VER_LANGUAGE="English (United States) [0x409]" />
</EXE>
</DATABASE>
 
Old April 3rd, 2004, 11:56 PM
Authorized User
  
Join Date: Apr 2004
Posts: 31
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to pigtail Send a message via Yahoo to pigtail
Default
I did more testing and found out that two Windows 2003 servers can run my script successfully, no limit on the number of rows returned.

But the script failed on other Windows 2003 servers, Windows 2000 servers, XP Professional. I have checked the VM Size used varied from 3M to 4M. All machines have configured to have at least 1.5M of virtual memory allocated.

I also noticed that most of the time, the word 'Done' is shown in the lower left-hand corner of the browser. Right before the browser crashed, it showed the URL for the dataread.asp on the lower left-hand corner of the browser. So, I wonder if it choked while dataread was being executed for some reason.
 
Old April 4th, 2004, 05:31 AM
Imar's Avatar
Wrox Author
  
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default
To be honest: I don't know. Where did you get that massive error message?

Can you explain what exactly you're doing? What does dataread.asp return?

Could it be that the first page is still being processed while the next cycle starts? You could do something like this:

timerID = setTimeout("GetTable()", 10000);
timerEnabled = true;
function GetTable()
{
  if (timerEnabled == true)
  {
     // disable timer until we are ready
     timerEnabled = false;
     // Do processing here; get data, fill table etc
     // Enable timer again
     timerEnabled = true;
  }
}

This way, even if GetTable is called multiple times, it will only execute the code inside the function once.

HtH,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
 
Old April 4th, 2004, 10:07 AM
Authorized User
  
Join Date: Apr 2004
Posts: 31
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to pigtail Send a message via Yahoo to pigtail
Default
dataread.asp is the ASP page that reads the database and returns an array of rows in Reply.

I have changed the GetTable function but it still crashed after a minute refresh or so.

function GetTable() {
        if (timerEnabled == true)
        {
           timerEnabled = false;
            var oTableContainer = document.getElementById('oTableContainer');
            oTableContainer.src = "dataread.asp";
           timerEnabled = true;
            timerID = setTimeout("GetTable()", 5000);
    }

}

I have the following in the BODY under IFRAME.

<script type="text/javascript" language="JavaScript">
<!--
      timerEnabled = true;
      GetTable();


//-->
</script>

I used window.parent.ReceiveData(reply); to send the array back from the dataread.asp. Can it be possible that dataread.asp didn't know where to send it back for some reason? Is there anything I need to set up on the client side to use this feature?
Page 1 of 2 1 2





Similar Threads
Thread Thread Starter Forum Replies Last Post
How to refresh parent page amolpayal Javascript How-To 1 August 2nd, 2006 05:03 AM
Need to "Refresh" page fskilnik Dreamweaver (all versions) 3 October 20th, 2005 10:49 AM
page Refresh skicrud PHP How-To 2 August 25th, 2004 04:03 AM
Refresh Data on Page acdsky Classic ASP Basics 1 July 23rd, 2004 08:22 PM




Contact Us - Wrox - Privacy Statement - Top

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.