Hello,
I am having an issue and i think it has to do with the session variable...
The site Works fine on my local machine but when i load it on the server it loads the first couple pages but then gives me an error and if i wait for a while and hit refresh it works eventully...
i am getting info from mutiple forms that get put into multiple tables in a DB and i am calling the session variable "user" on different pages so i will hve a identifier in each table.
this is a piece of code that gets info puts it into a db and sends me to another page
<%@ language="JScript" %>
<!-- #include file="adojavas.inc" -->
<html>
<head>
<title>Self Assesment answers</title>
</head>
<body>
<%
var connect = Server.CreateObject("ADODB.Connection");
var recordSet = Server.CreateObject("ADODB.RecordSet");
connect.Open("DSN=excuse");
recordSet.Open("select * from SelfAssesment",connect, adOpenKeyset,adLockOptimistic);
var User = Session("USER")
var a = Request.Form("1")
var b = Request.Form("2")
var c = Request.Form("3")
var d = Request.Form("4")
var e = Request.Form("5")
var f = Request.Form("result1")
var g = Request.Form("6")
var h = Request.Form("result2")
var i = Request.Form("7")
var j = Request.Form("Result3")
var k = Request.Form("Result4")
recordSet.AddNew();
recordSet("User") = User
recordSet("Life") = a
recordSet("Approches") = b
recordSet("Goals") = c
recordSet("Changes") = d
recordSet("Attempts") = e
recordSet("Result1") = f
recordSet("Factors") = g
recordSet("Result2") = h
recordSet("Confidant") = i
recordSet("Busiest") = j
recordSet("Easiest") = k
recordSet.Update();
connect.Close();
connect = null;
Response.Redirect("Health.asp")
%>
%>
</body>
</html>
I can give you the site address if you want to have look at the whole thing...
Thanks
David
I am having an issue and i think it has to do with the session variable...
The site Works fine on my local machine but when i load it on the server it loads the first couple pages but then gives me an error and if i wait for a while and hit refresh it works eventully...
i am getting info from mutiple forms that get put into multiple tables in a DB and i am calling the session variable "user" on different pages so i will hve a identifier in each table.
this is a piece of code that gets info puts it into a db and sends me to another page
<%@ language="JScript" %>
<!-- #include file="adojavas.inc" -->
<html>
<head>
<title>Self Assesment answers</title>
</head>
<body>
<%
var connect = Server.CreateObject("ADODB.Connection");
var recordSet = Server.CreateObject("ADODB.RecordSet");
connect.Open("DSN=excuse");
recordSet.Open("select * from SelfAssesment",connect, adOpenKeyset,adLockOptimistic);
var User = Session("USER")
var a = Request.Form("1")
var b = Request.Form("2")
var c = Request.Form("3")
var d = Request.Form("4")
var e = Request.Form("5")
var f = Request.Form("result1")
var g = Request.Form("6")
var h = Request.Form("result2")
var i = Request.Form("7")
var j = Request.Form("Result3")
var k = Request.Form("Result4")
recordSet.AddNew();
recordSet("User") = User
recordSet("Life") = a
recordSet("Approches") = b
recordSet("Goals") = c
recordSet("Changes") = d
recordSet("Attempts") = e
recordSet("Result1") = f
recordSet("Factors") = g
recordSet("Result2") = h
recordSet("Confidant") = i
recordSet("Busiest") = j
recordSet("Easiest") = k
recordSet.Update();
connect.Close();
connect = null;
Response.Redirect("Health.asp")
%>
%>
</body>
</html>
I can give you the site address if you want to have look at the whole thing...
Thanks
David
