for each of the 3 times you create the SQL to be executed, output it to the screen using a response.write before you execute it to see what the actual SQL statement the system is trying to execute is (Make sure buffering is turned off on the server during this testing to see the output)
We...
you don't say what database you are using so if it is Access, this suggestion is straight forward enough, if it is SQL or Oracle or other you might have to do a bit of work to get Access to talk to your database before you can use this
On the combining question, you are looking to INNER JOIN...
<SCRIPT language=Javascript>
function refreshPeriodic() {
location.reload();
}
timerID = setTimeout("refreshPeriodic()",60000);
</SCRIPT>
Put this at the start of your ASP page and it forces a reload of the page every 60 seconds or 60000 miliseconds
I assume your ticket numbers...
I have set up my web page to authenticate using clear text to force a login each time a new browser window accesses my page - so far so good
I now want to log the user out so the next time a user accesses the site they too are prompted to log in. I kill the session and redirect them off to an...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.