Sorry, I was trying a few different things to see if the variable was working, I was trying to see if I could make it work on either page.
Here is what I had before I changed things:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<!--#include file="../Connections/Seedling.asp" -->
<%
Dim Agency
Dim Agency_numRows
Set Agency = Server.CreateObject("ADODB.Recordset")
Agency.ActiveConnection = MM_Seedling_STRING
Agency.Source = "SELECT * FROM dbo.sdagency_tbl ORDER BY agency ASC"
Agency.CursorType = 0
Agency.CursorLocation = 2
Agency.LockType = 1
Agency.Open()
Agency_numRows = 0
%>
<%
Dim Recordset1
Dim Recordset1_numRows
Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_Seedling_STRING
Recordset1.Source = "SELECT * FROM dbo.sdtxn_tbl ORDER BY stocid"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()
Recordset1_numRows = 0
%>
<%
' *** Recordset Stats, Move To Record, and Go To Record: declare stats variables
Dim Agency_total
Dim Agency_first
Dim Agency_last
' set the record count
Agency_total = Agency.RecordCount
' set the number of rows displayed on this page
If (Agency_numRows < 0) Then
Agency_numRows = Agency_total
Elseif (Agency_numRows = 0) Then
Agency_numRows = 1
End If
' set the first and last displayed record
Agency_first = 1
Agency_last = Agency_first + Agency_numRows - 1
' if we have the correct record count, check the other stats
If (Agency_total <> -1) Then
If (Agency_first > Agency_total) Then
Agency_first = Agency_total
End If
If (Agency_last > Agency_total) Then
Agency_last = Agency_total
End If
If (Agency_numRows > Agency_total) Then
Agency_numRows = Agency_total
End If
End If
%>
<%
' *** Recordset Stats: if we don't know the record count, manually count them
If (Agency_total = -1) Then
' count the total records by iterating through the recordset
Agency_total=0
While (Not Agency.EOF)
Agency_total = Agency_total + 1
Agency.MoveNext
Wend
' reset the cursor to the beginning
If (Agency.CursorType > 0) Then
Agency.MoveFirst
Else
Agency.Requery
End If
' set the number of rows displayed on this page
If (Agency_numRows < 0 Or Agency_numRows > Agency_total) Then
Agency_numRows = Agency_total
End If
' set the first and last displayed record
Agency_first = 1
Agency_last = Agency_first + Agency_numRows - 1
If (Agency_first > Agency_total) Then
Agency_first = Agency_total
End If
If (Agency_last > Agency_total) Then
Agency_last = Agency_total
End If
End If
%>
<%
' *** Validate request to log in to this site.
MM_LoginAction = Request.ServerVariables("URL")
If Request.QueryString<>"" Then MM_LoginAction = MM_LoginAction + "?" + Server.HTMLEncode(Request.QueryString)
MM_valUsername=CStr(Request.Form("username"))
If MM_valUsername <> "" Then
MM_fldUserAuthorization=""
MM_redirectLoginSuccess="Logged-In Page.asp"
MM_redirectLoginFailed="Failed Log-in.asp"
MM_flag="ADODB.Recordset"
set MM_rsUser = Server.CreateObject(MM_flag)
MM_rsUser.ActiveConnection = MM_Seedling_STRING
MM_rsUser.Source = "SELECT agency, password"
If MM_fldUserAuthorization <> "" Then MM_rsUser.Source = MM_rsUser.Source & "," & MM_fldUserAuthorization
MM_rsUser.Source = MM_rsUser.Source & " FROM dbo.user_authentication_tbl WHERE agency='" & Replace(MM_valUsername,"'","''") &"' AND password='" & Replace(Request.Form("password"),"'","''") & "'"
MM_rsUser.CursorType = 0
MM_rsUser.CursorLocation = 2
MM_rsUser.LockType = 3
MM_rsUser.Open
If Not MM_rsUser.EOF Or Not MM_rsUser.BOF Then
' username and password match - this is a valid user
Session("MM_Username") = MM_valUsername
If (MM_fldUserAuthorization <> "") Then
Session("MM_UserAuthorization") = CStr(MM_rsUser.Fields.Item(MM_fldUserAuthorization).Value)
Else
Session("MM_UserAuthorization") = ""
End If
if CStr(Request.QueryString("accessdenied")) <> "" And false Then
MM_redirectLoginSuccess = Request.QueryString("accessdenied")
End If
MM_rsUser.Close
Response.Redirect(MM_redirectLoginSuccess)
End If
MM_rsUser.Close
Response.Redirect(MM_redirectLoginFailed)
End If
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "
<html xmlns="
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>
<body>
<p> </p>
<p> </p>
<p> </p>
<form id="login" name="login" method="POST" action="Logged-In Page.asp">
<p>User Name
<input name="username" type="text" id="username" value="initial value" />
<p>
<p>
<p>
<p>Password
<input name="password" type="password" id="password" />
<p>
<p>
<input type="submit" name="Submit" value="Submit" />
</form>
<% session("varuser") = request.form("username") %>
</body>
</html>
<%
Agency.Close()
Set Agency = Nothing
%>
<%
Recordset1.Close()
Set Recordset1 = Nothing
%>
Logged-In Page:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<!--#include file="../Connections/Seedling.asp" -->
<%
Dim agency__MMColParam
agency__MMColParam = "1"
If (Request.Form("username") <> "") Then
agency__MMColParam = Request.Form("username")
End If
%>
<%
Dim agency
Dim agency_numRows
Set agency = Server.CreateObject("ADODB.Recordset")
agency.ActiveConnection = MM_Seedling_STRING
agency.Source = "SELECT * FROM dbo.sdtxn_tbl WHERE agency = '" + Replace(agency__MMColParam, "'", "''") + "'"
agency.CursorType = 0
agency.CursorLocation = 2
agency.LockType = 1
agency.Open()
agency_numRows = 0
%>
<%
Dim stocid
Dim stocid_numRows
Set stocid = Server.CreateObject("ADODB.Recordset")
stocid.ActiveConnection = MM_Seedling_STRING
stocid.Source = "SELECT * FROM dbo.sdtxn_tbl"
stocid.CursorType = 0
stocid.CursorLocation = 2
stocid.LockType = 1
stocid.Open()
stocid_numRows = 0
%>
<%
' *** Recordset Stats, Move To Record, and Go To Record: declare stats variables
Dim agency_total
Dim agency_first
Dim agency_last
' set the record count
agency_total = agency.RecordCount
' set the number of rows displayed on this page
If (agency_numRows < 0) Then
agency_numRows = agency_total
Elseif (agency_numRows = 0) Then
agency_numRows = 1
End If
' set the first and last displayed record
agency_first = 1
agency_last = agency_first + agency_numRows - 1
' if we have the correct record count, check the other stats
If (agency_total <> -1) Then
If (agency_first > agency_total) Then
agency_first = agency_total
End If
If (agency_last > agency_total) Then
agency_last = agency_total
End If
If (agency_numRows > agency_total) Then
agency_numRows = agency_total
End If
End If
%>
<%
' *** Recordset Stats, Move To Record, and Go To Record: declare stats variables
Dim stocid_total
Dim stocid_first
Dim stocid_last
' set the record count
stocid_total = stocid.RecordCount
' set the number of rows displayed on this page
If (stocid_numRows < 0) Then
stocid_numRows = stocid_total
Elseif (stocid_numRows = 0) Then
stocid_numRows = 1
End If
' set the first and last displayed record
stocid_first = 1
stocid_last = stocid_first + stocid_numRows - 1
' if we have the correct record count, check the other stats
If (stocid_total <> -1) Then
If (stocid_first > stocid_total) Then
stocid_first = stocid_total
End If
If (stocid_last > stocid_total) Then
stocid_last = stocid_total
End If
If (stocid_numRows > stocid_total) Then
stocid_numRows = stocid_total
End If
End If
%>
<%
' *** Recordset Stats: if we don't know the record count, manually count them
If (agency_total = -1) Then
' count the total records by iterating through the recordset
agency_total=0
While (Not agency.EOF)
agency_total = agency_total + 1
agency.MoveNext
Wend
' reset the cursor to the beginning
If (agency.CursorType > 0) Then
agency.MoveFirst
Else
agency.Requery
End If
' set the number of rows displayed on this page
If (agency_numRows < 0 Or agency_numRows > agency_total) Then
agency_numRows = agency_total
End If
' set the first and last displayed record
agency_first = 1
agency_last = agency_first + agency_numRows - 1
If (agency_first > agency_total) Then
agency_first = agency_total
End If
If (agency_last > agency_total) Then
agency_last = agency_total
End If
End If
%>
<%
Dim MM_paramName
%>
<%
' *** Move To Record and Go To Record: declare variables
Dim MM_rs
Dim MM_rsCount
Dim MM_size
Dim MM_uniqueCol
Dim MM_offset
Dim MM_atTotal
Dim MM_paramIsDefined
Dim MM_param
Dim MM_index
Set MM_rs = stocid
MM_rsCount = stocid_total
MM_size = stocid_numRows
MM_uniqueCol = ""
MM_paramName = ""
MM_offset = 0
MM_atTotal = false
MM_paramIsDefined = false
If (MM_paramName <> "") Then
MM_paramIsDefined = (Request.QueryString(MM_paramName) <> "")
End If
%>
<%
' *** Move To Record: handle 'index' or 'offset' parameter
if (Not MM_paramIsDefined And MM_rsCount <> 0) then
' use index parameter if defined, otherwise use offset parameter
MM_param = Request.QueryString("index")
If (MM_param = "") Then
MM_param = Request.QueryString("offset")
End If
If (MM_param <> "") Then
MM_offset = Int(MM_param)
End If
' if we have a record count, check if we are past the end of the recordset
If (MM_rsCount <> -1) Then
If (MM_offset >= MM_rsCount Or MM_offset = -1) Then ' past end or move last
If ((MM_rsCount Mod MM_size) > 0) Then ' last page not a full repeat region
MM_offset = MM_rsCount - (MM_rsCount Mod MM_size)
Else
MM_offset = MM_rsCount - MM_size
End If
End If
End If
' move the cursor to the selected record
MM_index = 0
While ((Not MM_rs.EOF) And (MM_index < MM_offset Or MM_offset = -1))
MM_rs.MoveNext
MM_index = MM_index + 1
Wend
If (MM_rs.EOF) Then
MM_offset = MM_index ' set MM_offset to the last possible record
End If
End If
%>
<%
' *** Move To Record: if we dont know the record count, check the display range
If (MM_rsCount = -1) Then
' walk to the end of the display range for this page
MM_index = MM_offset
While (Not MM_rs.EOF And (MM_size < 0 Or MM_index < MM_offset + MM_size))
MM_rs.MoveNext
MM_index = MM_index + 1
Wend
' if we walked off the end of the recordset, set MM_rsCount and MM_size
If (MM_rs.EOF) Then
MM_rsCount = MM_index
If (MM_size < 0 Or MM_size > MM_rsCount) Then
MM_size = MM_rsCount
End If
End If
' if we walked off the end, set the offset based on page size
If (MM_rs.EOF And Not MM_paramIsDefined) Then
If (MM_offset > MM_rsCount - MM_size Or MM_offset = -1) Then
If ((MM_rsCount Mod MM_size) > 0) Then
MM_offset = MM_rsCount - (MM_rsCount Mod MM_size)
Else
MM_offset = MM_rsCount - MM_size
End If
End If
End If
' reset the cursor to the beginning
If (MM_rs.CursorType > 0) Then
MM_rs.MoveFirst
Else
MM_rs.Requery
End If
' move the cursor to the selected record
MM_index = 0
While (Not MM_rs.EOF And MM_index < MM_offset)
MM_rs.MoveNext
MM_index = MM_index + 1
Wend
End If
%>
<%
' *** Move To Record: update recordset stats
' set the first and last displayed record
stocid_first = MM_offset + 1
stocid_last = MM_offset + MM_size
If (MM_rsCount <> -1) Then
If (stocid_first > MM_rsCount) Then
stocid_first = MM_rsCount
End If
If (stocid_last > MM_rsCount) Then
stocid_last = MM_rsCount
End If
End If
' set the boolean used by hide region to check if we are on the last record
MM_atTotal = (MM_rsCount <> -1 And MM_offset + MM_size >= MM_rsCount)
%>
<%
' *** Move To Record: update recordset stats
' set the first and last displayed record
agency_first = MM_offset + 1
agency_last = MM_offset + MM_size
If (MM_rsCount <> -1) Then
If (agency_first > MM_rsCount) Then
agency_first = MM_rsCount
End If
If (agency_last > MM_rsCount) Then
agency_last = MM_rsCount
End If
End If
' set the boolean used by hide region to check if we are on the last record
MM_atTotal = (MM_rsCount <> -1 And MM_offset + MM_size >= MM_rsCount)
%>
<%
' *** Go To Record and Move To Record: create strings for maintaining URL and Form parameters
Dim MM_keepNone
Dim MM_keepURL
Dim MM_keepForm
Dim MM_keepBoth
Dim MM_removeList
Dim MM_item
Dim MM_nextItem
' create the list of parameters which should not be maintained
MM_removeList = "&index="
If (MM_paramName <> "") Then
MM_removeList = MM_removeList & "&" & MM_paramName & "="
End If
MM_keepURL=""
MM_keepForm=""
MM_keepBoth=""
MM_keepNone=""
' add the URL parameters to the MM_keepURL string
For Each MM_item In Request.QueryString
MM_nextItem = "&" & MM_item & "="
If (InStr(1,MM_removeList,MM_nextItem,1) = 0) Then
MM_keepURL = MM_keepURL & MM_nextItem & Server.URLencode(Request.QueryString(MM_item))
End If
Next
' add the Form variables to the MM_keepForm string
For Each MM_item In Request.Form
MM_nextItem = "&" & MM_item & "="
If (InStr(1,MM_removeList,MM_nextItem,1) = 0) Then
MM_keepForm = MM_keepForm & MM_nextItem & Server.URLencode(Request.Form(MM_item))
End If
Next
' create the Form + URL string and remove the intial '&' from each of the strings
MM_keepBoth = MM_keepURL & MM_keepForm
If (MM_keepBoth <> "") Then
MM_keepBoth = Right(MM_keepBoth, Len(MM_keepBoth) - 1)
End If
If (MM_keepURL <> "") Then
MM_keepURL = Right(MM_keepURL, Len(MM_keepURL) - 1)
End If
If (MM_keepForm <> "") Then
MM_keepForm = Right(MM_keepForm, Len(MM_keepForm) - 1)
End If
' a utility function used for adding additional parameters to these strings
Function MM_joinChar(firstItem)
If (firstItem <> "") Then
MM_joinChar = "&"
Else
MM_joinChar = ""
End If
End Function
%>
<%
' *** Move To Record: set the strings for the first, last, next, and previous links
Dim MM_keepMove
Dim MM_moveParam
Dim MM_moveFirst
Dim MM_moveLast
Dim MM_moveNext
Dim MM_movePrev
Dim MM_urlStr
Dim MM_paramList
Dim MM_paramIndex
Dim MM_nextParam
MM_keepMove = MM_keepBoth
MM_moveParam = "index"
' if the page has a repeated region, remove 'offset' from the maintained parameters
If (MM_size > 1) Then
MM_moveParam = "offset"
If (MM_keepMove <> "") Then
MM_paramList = Split(MM_keepMove, "&")
MM_keepMove = ""
For MM_paramIndex = 0 To UBound(MM_paramList)
MM_nextParam = Left(MM_paramList(MM_paramIndex), InStr(MM_paramList(MM_paramIndex),"=") - 1)
If (StrComp(MM_nextParam,MM_moveParam,1) <> 0) Then
MM_keepMove = MM_keepMove & "&" & MM_paramList(MM_paramIndex)
End If
Next
If (MM_keepMove <> "") Then
MM_keepMove = Right(MM_keepMove, Len(MM_keepMove) - 1)
End If
End If
End If
' set the strings for the move to links
If (MM_keepMove <> "") Then
MM_keepMove = Server.HTMLEncode(MM_keepMove) & "&"
End If
MM_urlStr = Request.ServerVariables("URL") & "?" & MM_keepMove & MM_moveParam & "="
MM_moveFirst = MM_urlStr & "0"
MM_moveLast = MM_urlStr & "-1"
MM_moveNext = MM_urlStr & CStr(MM_offset + MM_size)
If (MM_offset - MM_size < 0) Then
MM_movePrev = MM_urlStr & "0"
Else
MM_movePrev = MM_urlStr & CStr(MM_offset - MM_size)
End If
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "
<html xmlns="
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>
<body>
<p> </p>
<form id="form1" name="form1" method="post" action="Data Page.asp">
<p>Welcome <%= Request("username") %>, you have successfuly logged in. </p>
<p> </p>
<p> </p>
<p>
<input type="submit" name="Submit" value="Continue" />
</p>
</form>
<%= session("varuser") %>
</body>
</html>
<%
agency.Close()
Set agency = Nothing
%>
<%
stocid.Close()
Set stocid = Nothing
%>
This is where the variable is not getting the values from the textbox.
