ASP / Javascript page not refreshing after update

I have the attached page, its a simple form to update information.
When I click "Save" the information is updated, but the information displayed on the page is the same as before.
If I navigate to another page and then go back the info I updated is there.

So ... page is not refreshing after update.

how to fix ?
page1.txt
LVL 1
AleksAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

pateljituCommented:
Please try attached code, basically have moved code to SELECT statement after the UPDATE is fired.

<%@LANGUAGE="JAVASCRIPT" CODEPAGE="1252"%>
<%
Response.Expires=-1500
Response.CacheControl="no-cache"
%>

<!--#BeginBlock-->
<!--#include file="../../Connections/CMS2003.asp" -->
<!--#include file="../../includes/bdot/scripts.asp"-->
<!--#BeginBlock-->

<%
var USAStates = Server.CreateObject("ADODB.Recordset");
USAStates.ActiveConnection = MM_CMS2003_STRING;
USAStates.Source = "SELECT State FROM dbo.USAStates ORDER BY State ASC";
USAStates.CursorType = 0;
USAStates.CursorLocation = 2;
USAStates.LockType = 1;
USAStates.Open();
var USAStates_numRows = 0;
%>

<%
var WorldCountries = Server.CreateObject("ADODB.Recordset");
WorldCountries.ActiveConnection = MM_CMS2003_STRING;
WorldCountries.Source = "SELECT *  FROM dbo.PaisesdelMundo";
WorldCountries.CursorType = 0;
WorldCountries.CursorLocation = 2;
WorldCountries.LockType = 1;
WorldCountries.Open();
var WorldCountries_numRows = 0;
%>

<%
var LawFirm__MMColParam = "0";
if (String(Session("FirmId")) != "undefined" && 
    String(Session("FirmId")) != "") { 
  LawFirm__MMColParam = String(Session("FirmId"));
}
%>
<%
var LawFirm = Server.CreateObject("ADODB.Recordset");
LawFirm.ActiveConnection = MM_CMS2003_STRING;
LawFirm.Source = "SELECT FirmId, FirmName, eimmigaccess, logo  FROM dbo.LawFirm  WHERE FirmId = "+ LawFirm__MMColParam.replace(/'/g, "''") + "";
LawFirm.CursorType = 0;
LawFirm.CursorLocation = 2;
LawFirm.LockType = 1;
LawFirm.Open();
var LawFirm_numRows = 0;
%>

<%
var LoginFiltered__MMColParam = "1";
if (String(Session("NewEmployerID")) != "undefined" && 
    String(Session("NewEmployerID")) != "") { 
  LoginFiltered__MMColParam = String(Session("NewEmployerID"));
}
%>
<%
var LoginFiltered = Server.CreateObject("ADODB.Recordset");
LoginFiltered.ActiveConnection = MM_CMS2003_STRING;
LoginFiltered.Source = "SELECT * FROM dbo.UserLogin WHERE UserId = "+ LoginFiltered__MMColParam.replace(/'/g, "''") + "";
LoginFiltered.CursorType = 0;
LoginFiltered.CursorLocation = 2;
LoginFiltered.LockType = 1;
LoginFiltered.Open();
var LoginFiltered_numRows = 0;
%>

<%
var AcctManagertitle = Server.CreateObject("ADODB.Recordset");
AcctManagertitle.ActiveConnection = MM_CMS2003_STRING;
AcctManagertitle.Source = "Select * from parameters  where paramnm = 'emptcont'";
AcctManagertitle.CursorType = 0;
AcctManagertitle.CursorLocation = 2;
AcctManagertitle.LockType = 1;
AcctManagertitle.Open();
var AcctManagertitle_numRows = 0;
%>

<%
var Attys__MMColParam1 = "0";
if (String(Session("FirmId")) != "undefined" && 
    String(Session("FirmId")) != "") { 
  Attys__MMColParam1 = String(Session("FirmId"));
}
%>
<%
var Attys = Server.CreateObject("ADODB.Recordset");
Attys.ActiveConnection = MM_CMS2003_STRING;
Attys.Source = "SELECT userid, maidennm, mailstr  FROM Users  WHERE FirmID ='"+ Attys__MMColParam1.replace(/'/g, "''") + "' and (UserType ='attorney' OR UserType ='paralegal') and archivedcont = 0  ORDER BY MailStr";
Attys.CursorType = 0;
Attys.CursorLocation = 2;
Attys.LockType = 1;
Attys.Open();
var Attys_numRows = 0;
%>
<%
var EmployerDetails__MMColParam = "0";
if (String(Request.querystring("NewEmployerId")) != "undefined" && 
    String(Request.querystring("NewEmployerId")) != "") { 
  EmployerDetails__MMColParam = String(Request.querystring("NewEmployerId"));
}
%>
<%
var EmployerDetails__MMColParam2 = "0";
if (String(Session("Firmid")) != "undefined" && 
    String(Session("Firmid")) != "") { 
  EmployerDetails__MMColParam2 = String(Session("Firmid"));
}
%>
<!--#BeginBlock-->

<%
// *** Edit Operations: declare variables

// set the form action variable
var MM_editAction = Request.ServerVariables("SCRIPT_NAME");
if (Request.QueryString) {
  MM_editAction += "?" + Server.HTMLEncode(Request.QueryString);
}

// boolean to abort record edit
var MM_abortEdit = false;
%>
<%
if (String(Request("MM_update")) == "CreateContact") {
  if (!MM_abortEdit) {
    // execute the update
	
    var MM_editCmd = Server.CreateObject ("ADODB.Command");
    MM_editCmd.ActiveConnection = MM_CMS2003_STRING;
    MM_editCmd.CommandText = "UPDATE dbo.Users SET MaidenNm = ?, Archivedcont = ?, PpIssueCountry = ?, SSN = ?, I797 = ?, ConsulateName = ?, I94 = ?, Nationality = ?, Pob = ?, PobCountry = ?, Updatedby = ?, LastUpdate = ?, ContactId = ?, DocI20stat = ?, PPIssuedate = ?, Docstatusstat = ?, MS = ? WHERE UserId = ?";
    MM_editCmd.Prepared = true;
    MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param1", 201, 1, 60, Request.Form("CompanyName"))); // adLongVarChar
    MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param2", 5, 1, -1, (String(Request.Form("status")) != "undefined" && String(Request.Form("status")) != "") ? Request.Form("status") : null)); // adDouble
    MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param3", 201, 1, 40, Request.Form("IRSTax"))); // adLongVarChar
    MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param4", 201, 1, 11, Request.Form("SSN"))); // adLongVarChar
    MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param5", 201, 1, 20, Request.Form("NAICS"))); // adLongVarChar
    MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param6", 201, 1, 300, Request.Form("BusinessType"))); // adLongVarChar
    MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param7", 201, 1, 20, Request.Form("Year"))); // adLongVarChar
    MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param8", 201, 1, 40, Request.Form("No.Employees"))); // adLongVarChar
    MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param9", 201, 1, 40, Request.Form("GrossIncome"))); // adLongVarChar
    MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param10", 201, 1, 40, Request.Form("NetIncome"))); // adLongVarChar
    MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param11", 5, 1, -1, (String(Request.Form("Updatedby")) != "undefined" && String(Request.Form("Updatedby")) != "") ? Request.Form("Updatedby") : null)); // adDouble
    MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param12", 135, 1, -1, (String(Request.Form("LastUpdate")) != "undefined" && String(Request.Form("LastUpdate")) != "") ? Request.Form("LastUpdate") : null)); // adDBTimeStamp
    MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param13", 201, 1, 25, Request.Form("acctmng"))); // adLongVarChar
    MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param14", 5, 1, -1, (String(Request.Form("enablecleanup")) != "undefined" && String(Request.Form("enablecleanup")) != "") ? 1 : 0)); // adDouble
    MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param15", 135, 1, -1, (String(Request.Form("enableduntil")) != "undefined" && String(Request.Form("enableduntil")) != "") ? Request.Form("enableduntil") : null)); // adDBTimeStamp
    MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param16", 5, 1, -1, (String(Request.Form("empfrms")) != "undefined" && String(Request.Form("empfrms")) != "") ? 1 : 0)); // adDouble
    MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param17", 201, 1, 20, Request.Form("Empformstext"))); // adLongVarChar
    MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param18", 5, 1, -1, (String(Request.Form("MM_recordId")) != "undefined" && String(Request.Form("MM_recordId")) != "") ? Request.Form("MM_recordId") : null)); // adDouble
    MM_editCmd.Execute();
    MM_editCmd.ActiveConnection.Close();
  }
}
%>
<%
var EmployerDetails_cmd = Server.CreateObject ("ADODB.Command");
EmployerDetails_cmd.ActiveConnection = MM_CMS2003_STRING;
EmployerDetails_cmd.CommandText = "SELECT * FROM dbo.Users WHERE userid = ? and firmid = ?";
EmployerDetails_cmd.Prepared = true;
EmployerDetails_cmd.Parameters.Append(EmployerDetails_cmd.CreateParameter("param1", 5, 1, -1, EmployerDetails__MMColParam)); // adDouble
EmployerDetails_cmd.Parameters.Append(EmployerDetails_cmd.CreateParameter("param2", 5, 1, -1, EmployerDetails__MMColParam2)); // adDouble

var EmployerDetails = EmployerDetails_cmd.Execute();
var EmployerDetails_numRows = 0;
%>
<!--#BeginBlock-->

<html>
<head>
<title>Employer Details</title>
<link href="../../css/CMS.css" rel="stylesheet" type="text/css">
<link href="../../SpryAssets/SpryValidationTextField.css" rel="stylesheet" type="text/css">
<script type="text/javascript" src="../../ScriptLibrary/jquery-latest.pack.js"></script>
<script type="text/javascript" src="../../ScriptLibrary/dmxTooltips.js"></script>
<script src="../../SpryAssets/SpryValidationTextField.js" type="text/javascript"></script>
<script language="JavaScript" type="text/javascript">
function setFocus() {
    document.CreateContact.CompanyName.focus();
    // form1 is the name of your form. myField is the name of your field that you want to set focus to
 }
</script>
</head>

<!--#BeginBlock-->

<body onLoad="setFocus()">
<table width="100%"  border="0" cellpadding="0" cellspacing="0">
  <tr>
    <td align="left" valign="top" width="5"><img src="../../Images/blank.gif" width="5" height="350"></td> 
    <td align="left" valign="top" height="282" width="771">
      <table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr valign="middle">
          <td width="100%"><table width="100%" border="0" cellpadding="0" cellspacing="0" class="Tabletitlesubyellow">
            <tr>
              <td colspan="6" background="../../Images/menus/separatortop.gif"><img src="../../Images/blank.gif" alt="" width="10" height="3" /></td>
            </tr>
            <tr>
              <td width="1%"><img src="../../Images/blank.gif" alt="" width="10" height="25" /></td>
              <td width="88%"><div align="left" class="bodytextTtileBlack"><span class="bodytext"><a href="../default.asp" target="_parent"><font color="#000000">Home</font></a> <font color="#000000">&gt;<a href="SearchViewsearchemployers.asp"><font color="#000000"> Sponsoring Employers </font></a> &gt;<span class="bodytexttitle"> <%=(EmployerDetails.Fields.Item("MaidenNm").Value)%></span></font></span></div></td>
              <td width="2%" align="center"><div align="right"></div></td>
              <td width="2%" align="right" valign="middle"><img src="../../Images/blank.gif" alt="" width="25" height="25" /></td>
              <td width="6%" align="right" valign="middle">&nbsp;</td>
              <td width="1%" align="right" valign="middle"></td>
            </tr>
            <tr>
              <td colspan="6" background="../../Images/menus/separatortop.gif"><img src="../../Images/blank.gif" alt="" width="10" height="3" /></td>
            </tr>
          </table></td>
        </tr>
        <tr valign="middle">
          <td background="../../Images/NavBars/mainbkgd.gif"><div align="center">
              <table width="503" border="0" align="left" cellpadding="0" cellspacing="0">
                <tr>
                  <td width="100"><a href="UpdateEmployerdetails.asp?NewEmployerId=<%=(EmployerDetails.Fields.Item("UserId").Value)%>"><img src="../../Images/NavBars/Employers/GeneralInfoon.gif" alt="General Information" name="General" width="100" height="21" border="0" id="General" /></a></td>
                  <td width="100"><div align="center"><a href="UpdateAddAddresses.asp?NewEmployerId=<%=(EmployerDetails.Fields.Item("UserId").Value)%>"><img src="../../Images/NavBars/Employers/Addressesoff.gif" alt="Addresses" name="Addresses" width="100" height="21" border="0" id="Addresses" onMouseOver="MM_swapImage('Addresses','','../../Images/NavBars/Employers/Addresseson.gif',1)" onMouseOut="MM_swapImgRestore()" /></a></div></td>
                  <td width="100"><a href="CorpUsers.asp?NewEmployerId=<%=(EmployerDetails.Fields.Item("UserId").Value)%>"><img src="../../Images/NavBars/Employers/Corpusersoff.gif" alt="Corporate Users" name="Corporate" width="100" height="21" border="0" id="Corporate" onMouseOver="MM_swapImage('Corporate','','../../Images/NavBars/Employers/Corpuserson.gif',1)" onMouseOut="MM_swapImgRestore()" /></a></td>
                  <td width="100"><a href="UpdateAttachments.asp?NewEmployerId=<%=(EmployerDetails.Fields.Item("UserId").Value)%>"><img src="../../Images/NavBars/Employers/Attachmentsoff.gif" alt="Attachments" name="Attachments" width="100" height="21" border="0" id="Attachments" onMouseOver="MM_swapImage('Attachments','','../../Images/NavBars/Employers/Attachmentson.gif',1)" onMouseOut="MM_swapImgRestore()" /></a></td>
                  <td width="100"><div align="center"><a href="UpdateComments.asp?NewEmployerId=<%=(EmployerDetails.Fields.Item("UserId").Value)%>"><img src="../../Images/NavBars/Employers/Commentsoff.gif" alt="Comments" name="Comments" width="100" height="21" border="0" id="Comments" onMouseOver="MM_swapImage('Comments','','../../Images/NavBars/Employers/Commentson.gif',1)" onMouseOut="MM_swapImgRestore()" /></a></div></td>
                
                  <td width="100"><div align="center"><a href="UpdateCases.asp?NewEmployerId=<%=(EmployerDetails.Fields.Item("UserId").Value)%>"><img src="../../Images/NavBars/Employers/Casesoff.gif" alt="Cases" name="Cases" width="100" height="21" border="0" id="Cases" onMouseOver="MM_swapImage('Cases','','../../Images/NavBars/Employers/Caseson.gif',1)" onMouseOut="MM_swapImgRestore()" /></a></div></td>
                  <td width="10"><img src="../../Images/NavBars/closingmain.gif" width="1" height="21" /></td>
                </tr>
              </table>
          </div></td>
        </tr>
      </table>
      <form ACTION="<%=MM_editAction%>" METHOD="POST" name="CreateContact" id="CreateContact">
        <table width="100%" border="0" cellpadding="0" cellspacing="0" class="bodytextTtileBlackBkgd">
          <tr>
            <td colspan="4" background="../../Images/menus/separatortop.gif"><img src="../../Images/blank.gif" width="10" height="3"></td>
          </tr>
          <tr>
            <td width="3%"><img src="../../Images/blank.gif" width="10" height="25"></td>
            <td width="67%"><div align="left" class="bodytextTtileBlack">General  Information</div></td>
            <td width="27%"><div align="right"> <span class="style1"> </span></div>
              <div align="right"></div></td>
            <td width="3%"><img src="../../Images/blank.gif" width="10" height="25"></td>
          </tr>
          <tr>
            <td colspan="4" background="../../Images/menus/separatortop.gif"><img src="../../Images/blank.gif" width="10" height="3"></td>
          </tr>
        </table>
        <input name="BtnSave" type="submit" class="bodytext" id="BtnSave" value="  Save Changes  ">
<br>
        <table width="100%" border="0" align="left" cellpadding="0" cellspacing="3">
          <tr>
            <td colspan="6" background="../../Images/menus/separatortop.gif"><img src="../../Images/blank.gif" width="10" height="3"></td>
          </tr>
          <tr>
            <td width="17%" align="default" class="bodytext">Employer Name  <img src="../../Images/requiredstar.gif" width="9" height="8"></td>
            <td colspan="3" align="default" class="bodytext"><span id="SpryEmployer">
              <label for="CompanyName"></label>
              <input name="CompanyName" type="text" class="bodytext" id="CompanyName" value="<%=(EmployerDetails.Fields.Item("MaidenNm").Value)%>" size="60" maxlength="60">
            <span class="textfieldRequiredMsg">A value is required.</span></span></td>
          </tr>
          <tr>
            <td colspan="6" background="../../Images/menus/separatortop.gif"><img src="../../Images/blank.gif" width="10" height="3"></td>
          </tr>
          <tr>
            <td align="default" class="bodytext">Status <img src="../../Images/requiredstar.gif" width="9" height="8"></td>
            <td colspan="3" align="default" class="bodytext"><% if (EmployerDetails("Archivedcont") == '0')  { %>
Active
  <label>
    <input <%=(((EmployerDetails.Fields.Item("Archivedcont").Value) == 0)?"checked=\"checked\"":"")%> name="status" type="radio" value="0">
    Archived
  <input <%=(((EmployerDetails.Fields.Item("Archivedcont").Value) == 1)?"checked=\"checked\"":"")%> name="status" type="radio" value="1">
  </label>
(<a href="ArchiveEmployerwarning.asp?NewEmployerId=<%=(EmployerDetails.Fields.Item("UserId").Value)%>" onClick="GP_popupConfirmMsg('Archiving an Employer will result in automatically archiving the following:\r\r1. Contacts linked to the Employer\r2. Cases linked to the Employer\r3. Corporate users linked to the Employer\r4. Family members of contacts linked to the Employer\r\rThis operation once completed CANNOT BE UNDONE. \r\rPlease confirm you wish to archive the Employer.');return document.MM_returnValue">Archive Employer and related files</a>)
<% } // end  %>
<% if (EmployerDetails("Archivedcont") == '1')  { %>
Active
<input <%=(((EmployerDetails.Fields.Item("Archivedcont").Value) == 0)?"checked=\"checked\"":"")%> name="status" type="radio" value="0">
Archived
<input <%=(((EmployerDetails.Fields.Item("Archivedcont").Value) == 1)?"checked=\"checked\"":"")%> name="status" type="radio" value="1">
<% } // end  %></td>
          </tr>
          <tr>
            <td colspan="5" background="../../Images/menus/separatortop.gif"><img src="../../Images/blank.gif" width="10" height="3"></td>
          </tr>
         
          <tr>
            <td align="default"><span class="bodytext">IRS Tax #</span></td>
            <td width="39%" align="default" class="bodytextTtileBlack"><span class="bodytext">
              <input name="IRSTax" type="text" class="bodytext" id="IRSTax" onFocus="mark(this,'#C2D5EB','#000000')" onBlur="mark(this,'#FFFFFF','#000000')" value="<%=(EmployerDetails.Fields.Item("PpIssueCountry").Value)%>" size="25" maxlength="40">
            </span></td>
            <td width="13%" align="default" class="bodytext">SSN (If not company)</td>
            <td width="31%" align="default" class="bodytextTtileBlack"><span class="bodytext">
              <input name="SSN" type="text" class="bodytext" id="SSN" onFocus="mark(this,'#C2D5EB','#000000')" onBlur="mark(this,'#FFFFFF','#000000')" value="<%=(EmployerDetails.Fields.Item("SSN").Value)%>" size="11" maxlength="11">
            </span></td>
          </tr>
           <tr>
            <td colspan="6" background="../../Images/menus/separatortop.gif"><img src="../../Images/blank.gif" width="10" height="3"></td>
          </tr>
          <tr>
            <td align="default">Business Type</td>
            <td align="default" class="bodytextTtileBlack"><textarea name="BusinessType" cols="40" rows="3" class="bodytext" id="BusinessType" onFocus="mark(this,'#C2D5EB','#000000')" onBlur="mark(this,'#FFFFFF','#000000')"><%=(EmployerDetails.Fields.Item("ConsulateName").Value)%></textarea></td>
            <td align="default" class="bodytext">NAICS # </td>
            <td align="default" class="bodytextTtileBlack"><span class="bodytext">
              <input name="NAICS" type="text" class="bodytext" id="NAICS" value="<%=(EmployerDetails.Fields.Item("I797").Value)%>" size="6" maxlength="6">
            </span></td>
          </tr>
      <tr>
            <td colspan="6" background="../../Images/menus/separatortop.gif"><img src="../../Images/blank.gif" width="10" height="3"></td>
          </tr>
          <tr>
            <td align="default">Year Established</td>
            <td align="default" class="bodytextTtileBlack"><span class="bodytext">
              <input name="Year" type="text" class="bodytext" id="Year" onFocus="mark(this,'#C2D5EB','#000000')" onBlur="mark(this,'#FFFFFF','#000000')" value="<%=(EmployerDetails.Fields.Item("I94").Value)%>" size="4" maxlength="4">
(yyyy) </span></td>
            <td align="default" class="bodytext">No. Employees</td>
            <td align="default" class="bodytextTtileBlack"><span class="bodytext">
              <input name="No.Employees" type="text" class="bodytext" id="No.Employees" onFocus="mark(this,'#C2D5EB','#000000')" onBlur="mark(this,'#FFFFFF','#000000')" value="<%=(EmployerDetails.Fields.Item("Nationality").Value)%>" size="10" maxlength="40">
            </span></td>
          </tr>
         <tr>
            <td colspan="6" background="../../Images/menus/separatortop.gif"><img src="../../Images/blank.gif" width="10" height="3"></td>
          </tr>
          <tr>
            <td align="default">Gross Income (Annual)</td>
            <td align="default" class="bodytextTtileBlack"><span class="bodytext">
              <input name="GrossIncome" type="text" class="bodytext" id="GrossIncome" onFocus="mark(this,'#C2D5EB','#000000')" onBlur="mark(this,'#FFFFFF','#000000')" value="<%=(EmployerDetails.Fields.Item("Pob").Value)%>" size="10" maxlength="40">
            </span></td>
            <td align="default" class="bodytext">Net Income (Annual)</td>
            <td align="default" class="bodytextTtileBlack"><span class="bodytext">
              <input name="NetIncome" type="text" class="bodytext" id="NetIncome" onFocus="mark(this,'#C2D5EB','#000000')" onBlur="mark(this,'#FFFFFF','#000000')" value="<%=(EmployerDetails.Fields.Item("PobCountry").Value)%>" size="10" maxlength="40">
              <input name="Updatedby" type="hidden" id="Updatedby" value="<%= Session("UserID") %>">
            </span></td>
          </tr>
        <tr>
            <td colspan="6" background="../../Images/menus/separatortop.gif"><img src="../../Images/blank.gif" width="10" height="3"></td>
          </tr>
          <tr>
            <td align="default">Last Updated on</td>
            <td align="default" class="bodytextTtileBlack"><span class="bodytext">
              <input name="LastUpdate" type="text" class="bodytext" id="LastUpdate" value="<%= DoDateTime((EmployerDetails.Fields.Item("LastUpdate").Value), 2, 9225) %>" size="10" maxlength="10">
(mm/dd/yyyy) </span></td>
            <td align="default" class="bodytext">&nbsp;</td>
            <td align="default" class="bodytextTtileBlack">&nbsp;</td>
          </tr>
          
          <tr>
            <td colspan="4" align="default"><table width="100%" border="0" cellpadding="0" cellspacing="0" class="bodytextTtileBlackBkgd">
              <tr>
                <td colspan="4" background="../../Images/menus/separatortop.gif"><img src="../../Images/blank.gif" width="10" height="3"></td>
              </tr>
              <tr>
                <td width="3%"><img src="../../Images/blank.gif" width="10" height="25"></td>
                <td width="67%"><div align="left" class="bodytextTtileBlack">Preferences</div></td>
                <td width="27%"><div align="right"> <span class="style1"> </span></div>
                  <div align="right"></div></td>
                <td width="3%"><img src="../../Images/blank.gif" width="10" height="25"></td>
              </tr>
              <tr>
                <td colspan="4" background="../../Images/menus/separatortop.gif"><img src="../../Images/blank.gif" width="10" height="3"></td>
              </tr>
            </table></td>
          </tr>
           
          <tr>
            <td align="default"><span class="bodytext"><%=(AcctManagertitle.Fields.Item("ParamVal").Value)%></span></td>
            <td align="default" class="bodytextTtileBlack"><span class="bodytext">
              <select name="acctmng" class="bodytext" id="acctmng">
                <option value="" <%=(("" == (EmployerDetails.Fields.Item("contactid").Value))?"SELECTED":"")%>>Please make a selection</option>
                <% 
while (!Attys.EOF) {
%>
                <option value="<%=(Attys.Fields.Item("userid").Value)%>" <%=((Attys.Fields.Item("userid").Value == (EmployerDetails.Fields.Item("contactid").Value))?"SELECTED":"")%> ><%=(Attys.Fields.Item("mailstr").Value)%>&nbsp;<%=(Attys.Fields.Item("maidennm").Value)%></option>
                <%
  Attys.MoveNext();
}
if (Attys.CursorType > 0) {
  if (!Attys.BOF) Attys.MoveFirst();
} else {
  Attys.Requery();
}
%>
              </select>
            </span></td>
            <td align="default" class="bodytext">&nbsp;</td>
            <td align="default" class="bodytextTtileBlack">&nbsp;</td>
          </tr>
           <tr>
            <td colspan="6" background="../../Images/menus/separatortop.gif"><img src="../../Images/blank.gif" width="10" height="3"></td>
          </tr>
          <tr>
            <td align="default">Database cleanup</td>
            <td colspan="3" align="default" class="bodytextTtileBlack"><table width="100%" border="0" cellspacing="0" cellpadding="0">
              <tr>
                <td width="311" valign="middle"><span class="bodytext">
                  <input <%=(((EmployerDetails.Fields.Item("DocI20stat").Value) == 1)?"checked=\"checked\"":"")%> name="enablecleanup" type="checkbox" class="bodytext" id="enablecleanup" value="1">
                  (Check to enable) &nbsp;&nbsp;Database Cleanup link expires on</span></td>
                <td width="64"><span class="bodytext">
                  <input name="enableduntil" type="text" class="bodytext" id="enableduntil" onBlur="WAValidateDT(document.forms[0].enableduntil,'',true,/.*/,'mm/dd/yyyy','','',false,/.*/,'','','',document.forms[0].enableduntil,0,false)" value="<%= DoDateTime((EmployerDetails.Fields.Item("PPissuedate").Value), 2, 9225) %>" size="10" maxlength="10">
                </span></td>
                <td width="25"><a href="javascript:;"><img src="../../Images/minical.gif" name="calexp" width="22" height="22" border="0" id="calexp" onClick="KW_expertCalendar('January','February','March','April','May','June','July','August','September','October','November','December','Su','Mo','Tu','We','Th','Fr','Sa','enableduntil','mm','/','dd','/','y','0','0','0','-1','-1','-1','0',this,-1,-1,170,140,'&lt;&lt;','&gt;&gt;','&lt;&lt;','&gt;&gt;','',0,'../../css/calendar.css','#ffffff')"></a></td>
                <td width="81" class="bodytext"> (mm/dd/yyyy) </td>
                <td width="480" class="bodytext"><img src="../../Images/iconmoreinfo.gif" alt="Enabling &quot;Database Cleanup&quot; will allow the Employer to close and archive cases and contacts from the Employer Module." width="17" height="17"></td>
              </tr>
            </table></td>
          </tr>
       <tr>
            <td colspan="6" background="../../Images/menus/separatortop.gif"><img src="../../Images/blank.gif" width="10" height="3"></td>
          </tr>
          <tr>
            <td align="default">Print Watermark</td>
            <td colspan="3" align="default" class="bodytextTtileBlack"><input <%=(((EmployerDetails.Fields.Item("Docstatusstat").Value) == 1)?"checked=\"checked\"":"")%> name="empfrms" type="checkbox" id="empfrms" value="1">
            <span class="bodytext"> <font class="bodytext">(If   checked, forms printed by Employer and Client/Contact will print with   watermark)</font></span></td>
          </tr>
        <tr>
            <td colspan="6" background="../../Images/menus/separatortop.gif"><img src="../../Images/blank.gif" width="10" height="3"></td>
          </tr>
          <tr>
            <td align="default">Watermark</td>
            <td colspan="3" align="default" class="bodytextTtileBlack"><input name="Empformstext" type="text" class="bodytext" id="Empformstext" value="<%=(EmployerDetails.Fields.Item("MS").Value)%>" size="5" maxlength="5">
            <span class="bodytext">(Example: DRAFT, COPY)</span></td>
          </tr>
          <tr>
            <td colspan="5" background="../../Images/menus/separatortop.gif"><img src="../../Images/blank.gif" width="10" height="3"></td>
          </tr>
          <tr>
            <td colspan="4" align="default" class="bodytextTtileBlack"><a href="../inbox/SearchViewsearch.asp"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
              <input name="BtnSave2" type="submit" class="bodytext" id="BtnSave2" value="  Save Changes  ">
</font></a></td>
          </tr>
        </table>

                <input type="hidden" name="MM_update" value="CreateContact">
                <input type="hidden" name="MM_recordId" value="<%= EmployerDetails.Fields.Item("UserId").Value %>">
              </p>
      </form>
    </td>
  </tr>

</table>
<script type="text/javascript">
var sprytextfield1 = new Spry.Widget.ValidationTextField("SpryEmployer", "none", {validateOn:["blur", "change"]});
</script>
</body>
</html>

<!--#BeginBlock-->

<%
USAStates.Close();
%>
<%
WorldCountries.Close();
%>
<%
LawFirm.Close();
%>
<%
LoginFiltered.Close();
%>
<%
AcctManagertitle.Close();
%>
<%
Attys.Close();
%>
<%
EmployerDetails.Close();
%>

Open in new window

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
AleksAuthor Commented:
AWESOME !   thx thad did the trick
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ASP

From novice to tech pro — start learning today.