1.i have a varaible say "A" which i retrive in a select box in an htm file which connects to asp file number 1
2.then i check for some condition in the asp file number 1...the conditon is based
on a sql query which redirects(by including files) to the respective asp file number 3 or asp file number 4.
i want to know how i can retain the value of the "A" in the respective asp file number 3 or 4.
i tried using hidden value type for "A" but it works only within forms & i dont hv any form here.
iam enclosing the code as below:
<%Response.Buffer=True
'Retrive form fields into variables
EmpName=Request.ServerVariables("LOGON_USER"
WkEnd=Request.Form("WkEnd"
'Create the Sql command string
MySQLP="SELECT * FROM Plannedtable WHERE Proj_Lead='"&EmpName&"' And WkEnd='"&WkEnd&"'"
'Insert the form data into the Table
Set MyConn= Server.createObject("ADODB.Connection"
MyConn.open "FILEDSN=C:\WINNT\ODBC\Data Sources\Report.dsn"
Set RS = MyConn.Execute(MySQLP)
if NOT RS.BOF then
RS.movefirst
end if
if RS.EOF then %>
<!-- #include file="Enter.asp" -->
<%else%>
<!--#include file="Enter1.asp"-->
<%end if%>
pl note that the variable "A" here is "WkEnd"
2.then i check for some condition in the asp file number 1...the conditon is based
on a sql query which redirects(by including files) to the respective asp file number 3 or asp file number 4.
i want to know how i can retain the value of the "A" in the respective asp file number 3 or 4.
i tried using hidden value type for "A" but it works only within forms & i dont hv any form here.
iam enclosing the code as below:
<%Response.Buffer=True
'Retrive form fields into variables
EmpName=Request.ServerVariables("LOGON_USER"
WkEnd=Request.Form("WkEnd"
'Create the Sql command string
MySQLP="SELECT * FROM Plannedtable WHERE Proj_Lead='"&EmpName&"' And WkEnd='"&WkEnd&"'"
'Insert the form data into the Table
Set MyConn= Server.createObject("ADODB.Connection"
MyConn.open "FILEDSN=C:\WINNT\ODBC\Data Sources\Report.dsn"
Set RS = MyConn.Execute(MySQLP)
if NOT RS.BOF then
RS.movefirst
end if
if RS.EOF then %>
<!-- #include file="Enter.asp" -->
<%else%>
<!--#include file="Enter1.asp"-->
<%end if%>
pl note that the variable "A" here is "WkEnd"