passing js var to asp sql

okl · March 11th, 2005, 01:39 AM

hi, i trying to call savetime() on window onUnload.
But the sql give me an error.
Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error in UPDATE statement.

I debug the sql output it gave me blank, nothing shown.

Thanks for the help!

Code:

<html>
<head>
<title>Question 1</title>

<SCRIPT>
var interval = "";
var hr  = <%=objRst("hrs")%>;
var min = <%=objRst("mins")%>;
var sec = <%=objRst("secs")%>;

function startInterval()
{
    interval = window.setInterval("tTimer()",1000);
}

function stopInterval()
{
    window.clearInterval (interval);
    interval="";
}

function savetime()
{
<%
hrLeft = Request.form("Hr")
MinLeft = Request.form("Min")
SecLeft = request.form("Sec")

strSQL = "UPDATE Attempts SET Hrs=" & HrLeft & ",Mins=" & MinLeft & ",Secs=" & SecLeft & " WHERE studentID ='" & Session("StudID") & "' AND Paper = '" & Session("Paper") & "'"
'response.write strsql
'response.end
objConn.Execute (strSQL)
%>
}

function tTimer()
{
    document.timerform.display.value = hr+':'+zeroPad(min)+':'+ zeroPad(sec--);

    if (sec == -1)
    {
        if (min!="00")
        {
          min = min-1;
          sec = 59;
        }
        if (hr!=0)
        {
          hr = hr-1;
          min = 59;
          sec = 59;
        }
        if (hr==0 && min=="00")
        {
           stopInterval();
           alert ("TIME'S UP");
        }
   }
}
function zeroPad(digit)
{
    if (digit>9) {
      return digit;
    }
    return "0" + digit;
}
</SCRIPT>
</head>


<body bgcolor="#CCFFFF" onUnload="saveTime()">
<script>
startInterval();
</script>

  <form name="timerform" method="POST" action="Q1_Calc.asp" onsubmit="return validate()">

<input type="text" name="display" value="" size="10" readonly>

ChrisScott · March 11th, 2005, 05:01 AM

Hi okl,

You are probably not seeing your

Code:

response.write strsql

output in the browser because it is being written into a script block. If you view the source of the page, you should see what you are after.

BTW, your asp code is serverside & gets executed before the page is sent to the client machine. Therefore you db will get updated when the page builds, not when saveTime() gets called.

HTH,

Chris