Bill Henderson
asked on
Classic ASP, IIS 8 with SQL Server 2008 Express - one page keeps logging the user out on page load
HI,
I have a strange problem. Had a stable, well-running classic ASP application on an older Win 2008 web server that failed.
We recovered the database and application files and deployed them on a new Windows 2012 server (no choice, long story).
The application seems to be working, but there is one page - a critical page - that appears to be killing the user session state on page load. So when the user goes to save their form submittal, they just get the login page. This is true even if they just go to this page, and hit refresh.
Has anyone heard of this sort of thing? Other pages, presumably with more complicated programming are writing, modifying and deleting records as expected, but this one page no longer lets us do anything.
I've attached the page. (Actually it wouldn't let me attach ASP file - sorry for the long code paste:
The mande2 connection file is used on all other pages and works great.
The authentication check also appears on every other page of the site, and doesn't kick us on other pages.
Any suggestions would be great. I'm OK with chasing down error messages, but inexplicable session state behavior is pretty confounding.
Thanks
Bill
I have a strange problem. Had a stable, well-running classic ASP application on an older Win 2008 web server that failed.
We recovered the database and application files and deployed them on a new Windows 2012 server (no choice, long story).
The application seems to be working, but there is one page - a critical page - that appears to be killing the user session state on page load. So when the user goes to save their form submittal, they just get the login page. This is true even if they just go to this page, and hit refresh.
Has anyone heard of this sort of thing? Other pages, presumably with more complicated programming are writing, modifying and deleting records as expected, but this one page no longer lets us do anything.
I've attached the page. (Actually it wouldn't let me attach ASP file - sorry for the long code paste:
<%@LANGUAGE="VBSCRIPT"%>
<%
' functions are typically at the top or bottom of your page.
function checkIT(user_type,valueToCheckInclude, valueToCheckExclude)
checkInclude=false
checkExclude=true
arrUsertype=split(user_type,",")
for each number in arrUsertype
if cstr(number)=cstr(valueToCheckInclude) then
checkInclude=true
end if
if cstr(number)=cstr(valueToCheckExclude) then
checkExclude=false
end if
next
if checkInclude = true And checkExclude = true then
checkIT = true
else
checkIT = false
End if
end function
function checkIT2(user_type2,valueToCheckInclude2, valueToCheckExclude2)
user_type2=replace(user_type2," ","")
if instr(","& user_type2 &",",","& valueToCheckInclude2 &",")>0 AND instr(","& user_type2 &",",","& valueToCheckExclude2 &",")=0 then
checkIT2=True
else
checkIT2=False
end if
end function
%>
<!--#include file="Connections/mande2.asp" -->
<%
set oCon = server.CreateObject("ADODB.Connection")
oCon.open MM_mande_STRING
' *** Restrict Access To Page: Grant or deny access to this page
MM_authorizedUsers=""
MM_authFailedURL="login_redirect.asp"
MM_grantAccess=false
If Session("MM_Username") <> "" Then
If (true Or CStr(Session("MM_UserAuthorization"))="") Or _
(InStr(1,MM_authorizedUsers,Session("MM_UserAuthorization"))>=1) Then
MM_grantAccess = true
End If
End If
If Not MM_grantAccess Then
MM_qsChar = "?"
If (InStr(1,MM_authFailedURL,"?") >= 1) Then MM_qsChar = "&"
MM_referrer = Request.ServerVariables("URL")
if (Len(Request.QueryString()) > 0) Then MM_referrer = MM_referrer & "?" & Request.QueryString()
MM_authFailedURL = MM_authFailedURL & MM_qsChar & "accessdenied=" & Server.URLEncode(MM_referrer)
Response.Redirect(MM_authFailedURL)
End If
Dim UserRegion
Dim UserRegion_cmd
Dim UserRegion_numRows
Set UserRegion_cmd = Server.CreateObject ("ADODB.Command")
UserRegion_cmd.ActiveConnection = MM_mande_STRING
UserRegion_cmd.CommandText = "SELECT * FROM Regions where clientid = "&Session("clientid")&" ORDER BY regionname DESC"
UserRegion_cmd.Prepared = true
Set UserRegion = UserRegion_cmd.Execute
UserRegion_numRows = 0
%>
<%
Dim User__MMColParam
User__MMColParam = "1"
If (Session("MM_Username") <> "") Then
User__MMColParam = Session("MM_Username")
End If
%>
<%
Dim User
Dim User_cmd
Dim User_numRows
Set User_cmd = Server.CreateObject ("ADODB.Command")
User_cmd.ActiveConnection = MM_mande_STRING
User_cmd.CommandText = "SELECT * FROM Users WHERE clientid = "&Session("clientid")&" and UserName = ?"
User_cmd.Prepared = true
User_cmd.Parameters.Append User_cmd.CreateParameter("param1", 200, 1, 255, User__MMColParam) ' adVarChar
Set User = User_cmd.Execute
User_numRows = 0
%>
<%
Dim summary
Dim summary_cmd
Dim summary_numRows
Set summary_cmd = Server.CreateObject ("ADODB.Command")
summary_cmd.ActiveConnection = MM_mande_STRING
summary_cmd.CommandText = "SELECT Users.UserID, Users.UserFirstName, Sum(Jobs.AcceptedPrice) AS SumOfsalevalue, Avg(Jobs.AcceptedPrice) AS AvgOfsalevalue FROM Users INNER JOIN Jobs ON Users.UserID = Jobs.EstimatorAssigned GROUP BY users.userid, Users.UserFirstName"
summary_cmd.Prepared = true
Set summary = summary_cmd.Execute
summary_numRows = 0
%>
<%
Dim Repeat1__numRows
Dim Repeat1__index
Repeat1__numRows = -1
Repeat1__index = 0
summary_numRows = summary_numRows + Repeat1__numRows
%>
<!doctype html>
<html xml:lang="en-gb" lang="en-gb" >
<head>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<%
set which = oCon.execute("SELECT Server FROM Which")
%>
<% whichserver=(which("Server"))%>
<base href="<% =whichserver %>" />
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<title><%=session("compname")%> Powered by Simple Source CRM v4</title>
<link href="<% =whichserver %>" rel="canonical" />
<link rel="stylesheet" href="/templates/rt_stratos/css-compiled/menu-296f9540b6fdbc3d0fa92e37d50106a1.css" type="text/css" />
<link rel="stylesheet" href="/libraries/gantry/css/grid-responsive.css" type="text/css" />
<link rel="stylesheet" href="/templates/rt_stratos/css-compiled/bootstrap.css" type="text/css" />
<link rel="stylesheet" href="/templates/rt_stratos/css-compiled/master-10d632fb5e871d124a63de7b89359a4a.css" type="text/css" />
<link rel="stylesheet" href="/templates/rt_stratos/css-compiled/mediaqueries.css" type="text/css" />
<link rel="stylesheet" href="/templates/rt_stratos/css/rt_stratos-custom.css" type="text/css" />
<style type="text/css">
#rt-logo {background: url(/images/logo_final2.png) 50% 0 no-repeat !important;}
#rt-logo {width: 350px;height: 45px;}
.rt-grid-6 {width: 370px;}
.icon-help-huge:before {color:#333;}
@media (max-width: 480px) {
#rt-mainbody {margin-top:-100px;}
}
/* Smartphones to Tablets */
@media (min-width: 481px) and (max-width: 767px) {
#rt-mainbody {margin-top:-100px;}
}
/* Tablets */
@media (min-width: 768px) and (max-width: 959px) {
.menu-block{width:960px;}
}
/* Desktop */
@media (min-width: 960px) and (max-width: 1199px) {
.menu-block{width:1100px;}
}
/* Large Display */
@media (min-width: 1200px) {
.menu-block{width:1100px;}
}
</style>
<script src="/media/system/js/mootools-core.js" type="text/javascript"></script>
<script src="/media/system/js/core.js" type="text/javascript"></script>
<script src="/media/system/js/mootools-more.js" type="text/javascript"></script>
<script src="/plugins/system/rokbox/assets/js/rokbox.js" type="text/javascript"></script>
<script src="/templates/rt_stratos/js/rokmediaqueries.js" type="text/javascript"></script>
<script src="/modules/mod_roknavmenu/themes/default/js/rokmediaqueries.js" type="text/javascript"></script>
<script src="/modules/mod_roknavmenu/themes/default/js/responsive.js" type="text/javascript"></script>
<script type="text/javascript">
if (typeof RokBoxSettings == 'undefined') RokBoxSettings = {pc: '100'};
</script>
<script type="text/javascript">
function MM_openBrWindow(theURL,winName,features) { //v2.0
window.open(theURL,winName,features);
}
</script>
<script>
function changeColour(elementId) {
var interval = 1000;
var colour1 = "#ff0000"
var colour2 = "#000000";
if (document.getElementById) {
var element = document.getElementById(elementId);
//element.style.color = (element.style.color == colour1) ? colour2 : colour1;
setTimeout("changeColour('" + elementId + "')", interval);
}
}
//-->
</script>
</head>
<body onLoad="changeColour('flashtext')" class="logo-type-custom background-overlay-light background-type-light-diagonal-strips header-overlay-dark main-body-light font-family-stratos font-size-is-default menu-type-dropdownmenu layout-mode-responsive col12 option-com-content menu-sign-up ">
<div id="bodyFilm"></div>
<input type="hidden" name="HUserType" id="HUserType" value="<%=Session("UserType")%>" />
<div id="rt-page-surround">
<header id="rt-top-surround">
<div id="rt-drawer">
<div class="rt-container">
<div class="clear"></div>
</div>
</div>
<div id="rt-header">
<div class="rt-container">
<div class="rt-grid-6 rt-alpha">
<div class="rt-block logo-block">
<%
set rs = oCon.Execute("select CompanyLogoImage FROM GlobalSettings where clientid = "&Session("clientid") & " " )
If IsNull(rs("CompanyLogoImage")) OR rs.eof Then
%>
<a href="index.asp"> <img src="images/logo_final5.png" alt="Click for Home Page" style="height:45px;" /></a>
<% ELSE %>
<a href="index.asp"><img src="img/<%=session("complogo")%>" alt="Click for Home Page" style="height:45px;" /></a>
<% END IF %>
</div>
</div>
<br><br><br>
<div class="rt-block menu-block">
<div class="gf-menu-device-container"></div>
<ul class="gf-menu rt-desktop-menu l1 " >
<li class="item108" >
<a class="item icon" href="index.asp" >
<span class="icon-home"></span><span class="menu-text">Home</span> </a>
</li>
<% IF (instr(Session("UserTypes"),"1")) OR (instr(Session("UserTypes"),"2")) OR (instr(Session("UserTypes"),"7")) THEN %>
<li class="item117 active last" >
<a class="item icon" href="javascript:void(0);" >
<span class="icon-quote-right"></span><span class="menu-text">Bids</span> </a>
<div class="dropdown columns-1 " style="width:180px;">
<div class="column col1" style="width:180px;">
<ul class="l2">
<% IF (instr(Session("UserTypes"),"1")) OR (instr(Session("UserTypes"),"7")) THEN %> <li class="item1090" >
<a class="item" href="search_customer.asp" >
<span class="icon-search"></span><span class="menu-text"> Search Customers</span>
</a>
</li>
<li class="item2090" >
<a class="item" href="add_job.asp" >
<span class="icon-calendar"></span><span class="menu-text"> Schedule Bids</span>
</a>
</li> <li class="item1100" >
<a class="item" href="leads_manager.asp" >
<span class="icon-phone"></span><span class="menu-text"> Manage Leads</span>
</a>
</li>
<% END IF %>
<% IF checkIT2(Session("UserTypes"),"2","1") AND checkIT2(Session("UserTypes"),"2","7") THEN %>
<li class="item1090" >
<a class="item" href="search_customer2.asp" >
<span class="icon-search"></span><span class="menu-text"> Search Customers</span>
</a>
</li>
<li class="item2090" >
<a class="item" href="add_job2.asp" >
<span class="icon-calendar"></span><span class="menu-text"> Schedule Bids</span>
</a>
</li>
<% END IF %>
<% IF (instr(Session("UserTypes"),"2")) THEN %>
<li class="item2100" >
<a class="item" href="estimate_manager_created_estimator.asp" >
<span class="icon-wrench"></span><span class="menu-text"> Manage My Bids</span>
</a>
</li>
<% end if%>
</ul>
</div>
</div>
</li>
<% END IF %>
<% IF (instr(Session("UserTypes"),"1")) OR (instr(Session("UserTypes"),"3")) OR (instr(Session("UserTypes"),"7")) OR (instr(Session("UserTypes"),"8")) THEN %>
<li class="item117" >
<a class="item icon" href="javascript:void(0);" >
<span class="icon-truck"></span><span class="menu-text">Jobs</span> </a>
<div class="dropdown columns-1 " style="width:180px;">
<div class="column col1" style="width:180px;">
<ul class="l2">
<% IF (instr(Session("UserTypes"),"1")) OR (instr(Session("UserTypes"),"7")) OR (instr(Session("UserTypes"),"8")) THEN %> <li class="item4090" >
<a class="item" href="production_board.asp" >
<span class="icon-coffee"></span><span class="menu-text"> Production Board</span>
</a>
</li> <li class="item21034" >
<a class="item" href="acceptance_manager.asp" >
<span class="icon-wrench"></span><span class="menu-text"> Manage All Jobs</span>
</a>
</li>
<% END IF %>
<% IF (instr(Session("UserTypes"),"3")) THEN %>
<li class="item122 " >
<a class="item icon" href="job_manager.asp" >
<span class="icon-clock"></span><span class="menu-text">View My Jobs</span> </a>
</li>
<% End IF %>
<li class="item3092" >
<a class="item" href="javascript:void(0);" onClick="MM_openBrWindow('power_washer_calendar.asp','PWCalendar','width=300,height=700')"><span class="icon-table"></span><span class="menu-text"> Preworker Calendar</a></span>
</li>
<li class="item3093" >
<a class="item" href="javascript:void(0);" onClick="MM_openBrWindow('paint_crew_calendar.asp','JCCalendar','width=300,height=700')"><span class="icon-calendar"></span><span class="menu-text"> Job Crew Calendar</a></span>
</li>
<li class="item4096" >
<a class="item" href="index_complaints.asp" >
<span class="icon-lemon"></span><span class="menu-text"> Complaints</span>
</a>
</li>
<% IF (instr(Session("UserTypes"),"1")) OR (instr(Session("UserTypes"),"7")) THEN %>
<li class="item4097" >
<a class="item" href="jobs_to_invoice.asp" >
<span class="icon-tasks"></span><span class="menu-text"> Invoice</span>
</a>
</li>
<li class="item4098" >
<a class="item" href="payouts.asp" >
<span class="icon-bell-alt"></span><span class="menu-text"> Payouts</span>
</a>
</li>
<% END IF %> </ul>
</div>
</div>
</li>
<%
END IF
%>
<% IF (instr(Session("UserTypes"),"1")) OR (instr(Session("UserTypes"),"7")) THEN %>
<li class="item118 " >
<a class="item icon" href="javascript:void(0);" >
<span class="icon-bar-chart"></span><span class="menu-text">Reports</span> </a>
<div class="dropdown columns-1 " style="width:180px;">
<div class="column col1" style="width:180px;">
<ul class="l2">
<li class="item3090" >
<a class="item" href="index_leads.asp" >
<span class="icon-lightning"></span><span class="menu-text"> Leads Board</span>
</a>
</li> <li class="item3090432" > <a class="item" href="profit_by_estimator.asp" > <span class="icon-trophy"></span><span class="menu-text"> Profit Board</span></a></li>
<li class="item803090 parent">
<a class="item" href="javascript:void(0);" >
<span class="icon-paper-clip"></span><span class="menu-text"> Sales</span>
</a>
<div class="dropdown flyout columns-1 " style="width:180px;">
<div class="column col1" style="width:180px;">
<ul class="l3">
<li class="item3091" >
<a class="item" href="index_sales.asp" >
<span class="icon-inbox"></span><span class="menu-text"> Weekly Sales</span>
</a>
</li>
<li class="item3092" >
<a class="item" href="index_yoy.asp" >
<span class="icon-repeat"></span><span class="menu-text"> Year Over Year</span>
</a>
</li>
<li class="item223092" >
<a class="item" href="rev_month.asp" >
<span class="icon-calendar"></span><span class="menu-text"> Revenue/Month</span>
</a>
</li>
<li class="item333092" >
<a class="item" href="rev_job.asp" >
<span class="icon-wrench"></span><span class="menu-text"> Revenue/Job</span>
</a>
</li>
<li class="item343092" >
<a class="item" href="rev_estimator.asp" >
<span class="icon-chart"></span><span class="menu-text"> Revenue/Est</span>
</a>
</li> <li class="item353092" >
<a class="item" href="rev_crew.asp" >
<span class="icon-user"></span><span class="menu-text"> Revenue/Crew</span>
</a>
</li>
<li class="item333092" >
<a class="item" href="chart4.asp" >
<span class="icon-cancel"></span><span class="menu-text"> Rejections</span>
</a>
</li>
</ul>
</div>
</div>
</li>
<li class="item12349 parent" >
<a class="item" href="javascript:void(0);" >
<span class="icon-paste"></span><span class="menu-text"> Production</span> </a>
<div class="dropdown flyout columns-1 " style="width:180px;">
<div class="column col1" style="width:180px;">
<ul class="l3">
<li class="item143091" >
<a class="item" href="index_clients.asp" >
<span class="icon-inbox"></span><span class="menu-text"> Active Customers</span>
</a>
</li>
<li class="item153091" >
<a class="item" href="customer_satisfaction.asp" >
<span class="icon-thumbs-up"></span><span class="menu-text"> Customer Sat</span>
</a>
</li>
<li class="item163091" >
<a class="item" href="Weekly_Profit.asp" >
<span class="icon-cog"></span><span class="menu-text"> Foreman Weekly</span>
</a>
</li>
<li class="item173091" >
<a class="item" href="Weekly_WageHours.asp" >
<span class="icon-money"></span><span class="menu-text"> Wages Weekly</span>
</a>
</li>
</ul>
</li>
<li class="item3093 parent" >
<a class="item" href="javascript:void(0);" >
<span class="icon-plus"></span><span class="menu-text"> Profit</span>
</a>
<div class="dropdown flyout columns-1 " style="width:180px;">
<div class="column col1" style="width:180px;">
<ul class="l3">
<li class="item4423092" >
<a class="item" href="profit_month.asp" >
<span class="icon-calendar"></span><span class="menu-text"> Profit/Month</span>
</a>
</li>
<li class="item4433092" >
<a class="item" href="profit_job.asp" >
<span class="icon-wrench"></span><span class="menu-text"> Profit/Job</span>
</a>
</li>
<li class="item4443092" >
<a class="item" href="profit_estimator.asp" >
<span class="icon-chart"></span><span class="menu-text"> Profit/Est</span>
</a>
</li>
<li class="item44334092" >
<a class="item" href="marketing_breakdown.asp" >
<span class="icon-bullhorn"></span><span class="menu-text"> Marketing ROI</span>
</a>
</li>
</ul>
</li>
</ul></div></div>
</li>
<% END IF %>
<% IF (instr(Session("UserTypes"),"1")) OR (instr(Session("UserTypes"),"7")) OR (instr(Session("UserTypes"),"8")) THEN %>
<div class="dropdown columns-1 " style="width:180px;">
<div class="column col1" style="width:180px;">
<ul class="l2">
<a class="item" href="index_clients.asp" >
<span class="icon-group"></span><span class="menu-text"> Active Customers</span>
</a>
</li>
<li class="item4095" >
<a class="item" href="customer_satisfaction.asp" >
<span class="icon-check"></span><span class="menu-text"> Customer Sat</span>
</a>
</li>
</ul></div></div>
</li>
<%
END IF
%>
<%if session("InternalMessagingYesNo") = True then%>
<li class="item120" >
<a class="item icon" href="javascript:void(0);" >
<span class="icon-comments"></span><span class="menu-text">Messages</span> </a>
<div class="dropdown columns-1 " style="width:180px;">
<div class="column col1" style="width:180px;">
<ul class="l2">
<%
'get counts
flash = "false"
set inbox = oCon.execute("SELECT count(*) as inboxcount FROM EmployeeMessages WHERE clientid = "&Session("clientid")&" and recipientid = "& Session("UserID") &" and Archived=0 ")
inboxcount = inbox("inboxcount")
inbox.close
if inboxcount = 0 then
set inbox = oCon.execute("SELECT count(*) as inboxcount FROM EmployeeMessages WHERE clientid = "&Session("clientid")&" and recipientid = "& Session("UserID") &" and Archived=0 and mustreply=1 and (messagestatus = 'Read' OR messagestatus = 'Unread') ")
inboxcount = inbox("inboxcount")
if cint(inboxcount) > 0 then
flash = "true"
end if
inbox.close
end if
set inbox = oCon.execute("SELECT count(*) as inboxcount FROM EmployeeMessages WHERE clientid = "&Session("clientid")&" and recipientid = "& Session("UserID") &" and Archived=0 and mustreply=1 and (messagestatus = 'Read' OR messagestatus = 'Unread') ")
rinboxcount = inbox("inboxcount")
if cint(rinboxcount) > 0 then
flash = "true"
end if
inbox.close
'if flash = "false"
set inbox = oCon.execute("SELECT count(*) as inboxcount FROM EmployeeMessages WHERE clientid = "&Session("clientid")&" and recipientid = "& Session("UserID") &" and messagestatus = 'Unread' ")
rinboxcount = inbox("inboxcount")
if cint(rinboxcount) > 0 then
flash = "true"
end if
inbox.close
'end if
set inbox = nothing
set sentbox = oCon.execute("SELECT count(*) as sentboxcount FROM EmployeeMessages WHERE clientid = "&Session("clientid")&" and Archived=0 and senderid = "& Session("UserID") &" ")
sentboxcount = sentbox("sentboxcount")
sentbox.close
set sentbox = nothing
oCon.execute("update employeemessages set Archived=1 WHERE (((employeemessages.[senderid])="& Session("UserID") &") AND ((employeemessages.[messagestatus])='Read' Or (employeemessages.[messagestatus])='Replied') AND ((DateDiff(DAY, messagedate, GETDATE())>10 )))")
if flash = "true" then
%>
<li class="item4090" >
<a id="flashtext" class="item" href="user_message.asp" >
<span class="icon-th-list"></span><span class="menu-text"> Open Messages (<%=inboxcount%>)</span>
</a>
</li>
<%
else
%>
<li class="item4090" >
<a class="item" href="user_message.asp" >
<span class="icon-th-list"></span><span class="menu-text"> Open Messages (<%=inboxcount%>)</span>
</a>
</li>
<%
end if
%>
<li class="item4100" >
<a class="item" href="sent_message.asp" >
<span class="icon-arrow-up"></span><span class="menu-text"> Sent Messages (<%=sentboxcount%>)</span>
</a>
</li>
<li class="item41300" >
<a class="item" href="user_message_archived.asp" >
<span class="icon-minus-sign"></span><span class="menu-text"> Archived Messages</span>
</a>
</li>
<li class="item4100" >
<a class="item" href="send_message.asp" >
<span class="icon-envelope-alt"></span><span class="menu-text"> Send New Message</span>
</a>
</li> </ul>
</div>
</div>
</li>
<%end if%>
<% IF (instr(Session("UserTypes"),"1")) OR (instr(Session("UserTypes"),"7")) THEN %>
<li class="item121" >
<a class="item icon" href="javascript:void(0);" >
<span class="icon-cogs"></span><span class="menu-text">Settings</span> </a>
<div class="dropdown columns-1 " style="width:180px;">
<div class="column col1" style="width:180px;">
<ul class="5l2">
<li class="item5090" >
<a class="item" href="global_configuration.asp" >
<span class="icon-globe"></span><span class="menu-text"> Main Settings</span>
</a>
</li>
<li class="item5491" >
<a class="item" href="emailmsg_manage.asp" >
<span class="icon-envelope-alt"></span><span class="menu-text"> Customer Emails</span>
</a>
</li>
<li class="item773093 parent" >
<a class="item" href="javascript:void(0);" >
<span class="icon-plus"></span><span class="menu-text"> User Settings</span>
</a>
<div class="dropdown flyout columns-1 " style="width:180px;">
<div class="column col1" style="width:180px;">
<ul class="l3">
<li class="item5091" >
<a class="item" href="user_manager.asp" >
<span class="icon-group"></span><span class="menu-text"> User Manager</span>
</a>
</li>
<li class="item5991" >
<a class="item" href="estimator_order.asp" >
<span class="icon-sort"></span><span class="menu-text"> Estimator Order</span>
</a>
</li>
<li class="item5891" >
<a class="item" href="message_manager.asp" >
<span class="icon-comment"></span><span class="menu-text"> Message Manager</span>
</a>
</li>
</ul></div></div>
<li class="item883093 parent" >
<a class="item" href="javascript:void(0);" >
<span class="icon-plus"></span><span class="menu-text"> Job Settings</span>
</a>
<div class="dropdown flyout columns-1 " style="width:180px;">
<div class="column col1" style="width:180px;">
<ul class="l3">
<li class="item5191" >
<a class="item" href="estimate_types_manager.asp" >
<span class="icon-briefcase"></span><span class="menu-text"> Job Types</span>
</a>
</li>
<li class="item5591" >
<a class="item" href="cancellation_reason_manager.asp" >
<span class="icon-cancel"></span><span class="menu-text"> Est Cancel Types</span>
</a>
</li><li class="item5691" >
<a class="item" href="job_cancellation_reason_manager.asp" >
<span class="icon-thumbs-down"></span><span class="menu-text"> Job Cancel Types</span>
</a>
</li>
<li class="item5391" >
<a class="item" href="dead_reasons_manager.asp" >
<span class="icon-minus"></span><span class="menu-text"> Rejection Types</span>
</a>
</li><li class="item5791" >
<a class="item" href="complaint_manager.asp" >
<span class="icon-lemon"></span><span class="menu-text"> Problem Types</span></a></li>
<%if session("DetailedMaterialsYesNo") = True then%>
<li class="item3215791" > <a class="item" href="material_category_manager.asp" > <span class="icon-tag"></span><span class="menu-text"> Manage Materials</span></a></li>
<% end if %>
</ul></div></div>
<li class="item993093 parent" >
<a class="item" href="javascript:void(0);" >
<span class="icon-plus"></span><span class="menu-text"> Marketing Settings</span>
</a>
<div class="dropdown flyout columns-1 " style="width:180px;">
<div class="column col1" style="width:180px;">
<ul class="l3">
<li class="item5291" >
<a class="item" href="referral_types_manager.asp" >
<span class="icon-bullhorn"></span><span class="menu-text"> Referral Types</span>
</a>
</li><li class="item5391" >
<a class="item" href="referral_spend_manager.asp" >
<span class="icon-list"></span><span class="menu-text"> Marketing Costs</span>
</a>
</li>
</ul></div></div>
<li class="item9883093 parent" >
<a class="item" href="javascript:void(0);" >
<span class="icon-plus"></span><span class="menu-text"> Data Export</span>
</a>
<div class="dropdown flyout columns-1 " style="width:180px;">
<div class="column col1" style="width:180px;">
<ul class="l3">
<li class="item1100" >
<a class="item" href="customers_export.asp" >
<span class="icon-cloud-download"></span><span class="menu-text"> Export Customers</span>
</a>
</li>
<li class="item12100" >
<a class="item" href="jobs_export.asp" >
<span class="icon-cloud-download"></span><span class="menu-text"> Export Jobs</span>
</a>
</li>
</ul></div></div>
</ul></div></div>
</li>
<% END IF %>
<% IF checkIT2(Session("UserTypes"),"2","7") or checkIT2(Session("UserTypes"),"3","7") or checkIT2(Session("UserTypes"),"4","7") or checkIT2(Session("UserTypes"),"5","7") or checkIT2(Session("UserTypes"),"6","7") or checkIT2(Session("UserTypes"),"8","7") THEN %>
<li class="item1223 " >
<a class="item icon" href="my_profile.asp" >
<span class="icon-pencil"></span><span class="menu-text">My Profile</span> </a>
</li>
<%
END IF
%>
<li class="item124" >
<a class="item icon" href="login_redirect.asp" >
<span class="icon-signout"></span><span class="menu-text">Logout</span> </a>
</li>
</ul> <div class="clear"></div>
</div>
<div class="clear"></div>
</div>
</div>
</header>
<div id="rt-transition">
<div id="rt-mainbody-surround">
<div class="rt-container">
<div id="rt-main" class="mb12">
<div class="rt-container">
<div class="rt-grid-12 ">
<div id="rt-mainbody">
<h2>Locate an Existing Customer</h2>
<form id="CustomerSearch" name="CustomerSearch" method="post" action="customer_results.asp">
<h2> </h2>
<table width="60%" border="0">
<tr>
<td><h4>Phone Number </h4></td>
<td><input type="text" name="PhoneNumber" id="PhoneNumber" />
</td>
</tr>
<tr>
<td><h4>Name</h4></td>
<td><input type="text" name="CustomerName" id="CustomerName" />
</td>
</tr>
<tr>
<td><h4>Street</h4></td>
<td><input type="text" name="Street" id="Street" /></td>
</tr>
<tr>
<td><h4>Comments</h4></td>
<td><input type="text" name="Comments" id="Comments" /></td>
</tr>
<tr>
<td> </td>
<td><input type="submit" name="Search" id="Search" value="Search" class="button" /></td>
</tr>
</table>
<table cellpadding="2" cellspacing="0" border="0">
<tr>
<td align="center"><input type="hidden" name="WADbSearch1" value="Submit" /></td>
</tr>
</table>
</form>
<p> </p>
<h1><br />
</h1>
<div class="clear"></div>
</div>
<br class="clearFloat" />
</div>
<div class="clear"></div>
</div>
</div>
</div>
</div>
</div>
<footer id="rt-footer-surround">
<div id="rt-footer">
<div class="rt-container">
<div class="rt-grid-8 rt-alpha">
<div class="rt-block box5 fp-footer-a">
<div class="module-surround">
<div class="module-content">
<div class="custombox5 fp-footer-a" >
<div class="rt-footer-logo" style="height:35px;" >
</div>
</div>
</div>
</div>
</div>
</div>
<div class="rt-grid-4 rt-omega">
<div class="rt-block fp-footer-b">
<div class="module-surround">
<div class="module-content">
<div class="custombox5 fp-footer-b" >
<br>
<a href="javascript:void(0);" ><i class="icon-question-sign icon-help-huge" onClick="MM_openBrWindow('/instructions/homepage.html','homepage','scrollbars=yes,resizable=yes,width=600,height=400')"></i></a>
</div>
</div>
</div>
</div>
</div>
<div class="clear"></div>
</div>
</div>
<div id="rt-copyright">
<div class="rt-container">
<div class="rt-grid-3 rt-alpha">
<div class="clear"></div>
</div>
<div class="rt-grid-7">
<div class="rt-block horizmenu rt-center hidden-phone">
<div class="module-surround">
<div class="module-content">
<ul class="nav menu">
<li class="item-134"></li></ul>
</div>
</div>
</div>
</div>
<div class="rt-grid-2 rt-omega">
<div class="clear"></div>
</div>
<div class="clear"></div>
</div>
</div>
</footer>
</div>
</body>
</html>
<%
User.Close()
Set User = Nothing
%>
<%
summary.Close()
Set summary = Nothing
%>
The mande2 connection file is used on all other pages and works great.
The authentication check also appears on every other page of the site, and doesn't kick us on other pages.
Any suggestions would be great. I'm OK with chasing down error messages, but inexplicable session state behavior is pretty confounding.
Thanks
Bill
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Still not resolved but much more narrowed down - thanks
ASKER