Hi,
I have an ASP page called CLIENT PAGE that calls up information from a database as well as a java applet hosted externally. The ASP page is constructed as follows:

CLIENT PAGE
<header.asp> is top navigation separate page with header and body tags
middle part contains tables, asp code and links to the database
<footer.asp> is a reference to asp page with footer information and closing body tag and html tag.

When you call the CLIENTPAGE.ASP, it loads the page in the browser with the URL http://www.domain.com/clientPage.asp?Client=1

When the page loads, the java applet on the page is suppose to list numerical information in a table. Upon intial loading, that information is not there, its only after refreshing the page that it appears.

I have added a javascript link to the header.asp page code to automatically refresh once after the page loads the first time,
here is the code:

================================================== ===============
var reloaded = false;
var loc=""+document.location;
loc = loc.indexOf("?reloaded=")!=-1?loc.substring(loc.indexOf("?reloaded=")+10,loc.l ength):"";
loc = loc.indexOf("&")!=-1?loc.substring(0,loc.indexOf("&")):loc;
reloaded = loc!=""?(loc=="true"):reloaded;

function reloadOnceOnly() {
    if (!reloaded)
        window.location.replace(window.location+"?reloaded =true");
}
================================================== ================

with: onload="reloadOnceOnly()" in the body tag

The idea is that the page laods and then reload with the java applet numbers appearing in the table.

Here is the error i get when I run this entire setup:
================================================== =
Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'id = 1?reloaded=true'.

/clientPage.asp, line 8
==============================

The CLIENT PAGE is retreiving info as follows:

==============================
strClient = Request("Client")

    DBOpen()

    ' write table contents
    Set rstemp = conntemp.execute("SELECT * FROM tbl_Client WHERE id = " & strClient)
    strClientName = rstemp("ClientName")
============================================

Any assistance would be greatly appreciated
thanks

Pablo

Hi Pablo,

I think your making it a bit to complicted for yourself and i presume you don't need to reload every page that uses the header.asp include.

A simple way to control this is on the initial link to the clienPage.asp pass though a variable to notify its the first time.

eg. clientPage.asp?PageStatus=firstload

Then simply add a metarefesh to execute if the variable matches first load, else just display the page.

Heres my example code

TDA

mmmm does look very confusing. To get id of your error change:
'id = 1?reloaded=true'.
to
'id = 1&reloaded=true'.

BTW : you have spaces in your querystring, these may cause a problem - I would want it to look like:
'id=1&reloaded=true'.

Wind is your friend
Matt