I need to add another field to my form

I need some Help adding one more field to my from if possible.
<!--#include virtual="/includes/asp/cms_header.asp"-->
 
<!-- MENUS -->
<!--#include virtual="/includes/asp/cms_right_menu.asp"-->
<!-- END MENUS -->
 
<script language="javascript" src="/includes/js/formutils.js" type="text/javascript"></script>
<script language="JavaScript">
 
function isValid() {
  with (document.myForm) {
     if (name.value =="") { // check For First Name
    alert("ATTENTION\n\n\n..\nName is required.\n..\n\n\n");
    name.focus();
	return false;
   }      
   if (ext.value =="") { // check For extention
    alert("ATTENTION!\n\n\n..\nExtension is required.\n..\n\n\n");
    ext.focus();
	return false;
   } 
   if (login.value =="") { // check Login is required.\n..\n\n\n");
    alert("ATTENTION\n\n\n..\nNetwork Credentials Required.\n..\n\n\n");
    login.focus();
	return false;
   }  
   if (password.value =="") { // check For Passord
    alert("ATTENTION\n\n\n..\nNetwork Password is required.\n..\n\n\n");
    password.focus();
	return false;
   }
   if (problem.value =="") { // check For problem
    alert("ATTENTION\n\n\n..\nproblem is required.\n..\n\n\n");
    problem.focus();
	return false;
   }  
 
 }
 return true;
}
    </script> 
<!-- BEGIN CONTENT BODY -->
		<div id="content_body">
		  <p class="page_title">Computer Work Order</p>
		  <% if Request.Form("Submit") = "Submit" then 
			set objRS = server.CreateObject("adodb.recordset")
			
			employee_name = replace(request.form("name"), "'", "''")
			problem = replace(request.form("problem"), "'", "''")
			problem = replace(problem, vbcrlf, "<br>")
			outputProblem = problem
			if request.Form("login") <> "" then
				problem = problem & "<br>Login: " & request.Form("login")
			end if
			if request.Form("password") <> "" then
				problem = problem & "<br>Password: " & request.Form("password")
			end if
			strSql = "set nocount on "
			strSql = strSql & "insert into wo (request_date,employee_name,employee_phone,problem,wo_type) values ("
			strSql = strSql & "'" & now() & "', "
			strSql = strSql & "'" & employee_name & "', "
			strSql = strSql & "'" & request.Form("ext") & "', "
			strSql = strSql & "'" & problem & "', "
			strSql = strSql & "1) "
			strSql = strSql & "select last_insert_id=@@IDENTITY "
			strSql = strSql & "set nocount off"
			objRS.open strSql, objConn
			%>
			<p class='body'>The work order has been submitted, for your reference here is the information you submitted:</p>
			<table cellpadding="3" cellspacing="0" border="0" class="body">
			<tr><td>Employee:&nbsp;</td><td><%= request.Form("name") %></td></tr>
			<tr><td>Extension:&nbsp;</td><td><%= request.Form("ext") %></td></tr>
			<tr><td valign="top">Description:&nbsp;</td><td><%= outputProblem %></td></tr>
			<tr><td>Work&nbsp;Order&nbsp;#:&nbsp;</td><td><%= objRS("last_insert_id") %></td></tr>
			</table>
			<p class="body"><a href="computer_work_order.asp">Click here</a> if you want to submit another Computer Work Order.</p>
			<p class="body"><a href="/">Back to CHCC Home</a></p>
		  <% else %>
		  
	      <p class="body">If you are submitting a Computer Work Order about a new hire, please use the <a href="/forms/new_hire.asp">New Hire / Replacement Request Form</a>.</p>
	      <form name="myForm" action="computer_work_order.asp" method="post" onSubmit="return isValid()">
		  <div class="body">
		  <table cellpadding="3" cellspacing="0" border="0">
		  <tr><td><span class="req">*&nbsp;</span>Name:</td><td><input type="text" name="name"></td></tr>
		  <tr><td><span class="req">*&nbsp;</span>Extension:</td><td><input type="text" name="ext"></td></tr>
		  <tr><td><span class="req">*&nbsp;</span>User Name:</td><td><input type="text" name="login"></td></tr>
		  <tr><td valign="top"><span class="req">*&nbsp;</span>Password:</td><td><input type="password" name="password"><br><font size="1">Your password will appear as *'s for safety</font></td></tr>
		  <tr><td valign="top"><span class="req">*&nbsp;</span>Problem:</td><td><textarea name="problem"></textarea></td></tr>
		  <tr><td colspan="2" align="right"><input type="submit" name="Submit" value="Submit"></td></tr>
		  </table>
		  </div>
		    </form>
	      <% end if %>
		  
		</div>
		<!-- END CONTENT BODY -->
 
<!--#include virtual="/includes/asp/cms_footer.asp"-->

Open in new window

5.bmp
CHCCITAsked:
Who is Participating?
 
Mark WoodConnect With a Mentor Network AdministratorCommented:
now you just need to add the location field to the database
<!--#include virtual="/includes/asp/cms_header.asp"-->
 
<!-- MENUS -->
<!--#include virtual="/includes/asp/cms_right_menu.asp"-->
<!-- END MENUS -->
 
<script language="javascript" src="/includes/js/formutils.js" type="text/javascript"></script>
<script language="JavaScript">
 
function isValid() {
  with (document.myForm) {
     if (name.value =="") { // check For First Name
    alert("ATTENTION\n\n\n..\nName is required.\n..\n\n\n");
    name.focus();
	return false;
   }      
   if (ext.value =="") { // check For extention
    alert("ATTENTION!\n\n\n..\nExtension is required.\n..\n\n\n");
    ext.focus();
	return false;
   } 
   if (login.value =="") { // check Login is required.\n..\n\n\n");
    alert("ATTENTION\n\n\n..\nNetwork Credentials Required.\n..\n\n\n");
    login.focus();
	return false;
   }  
   if (password.value =="") { // check For Passord
    alert("ATTENTION\n\n\n..\nNetwork Password is required.\n..\n\n\n");
    password.focus();
	return false;
   }
   if (problem.value =="") { // check For problem
    alert("ATTENTION\n\n\n..\nproblem is required.\n..\n\n\n");
    problem.focus();
	return false;
   }  
 
 }
 return true;
}
    </script> 
<!-- BEGIN CONTENT BODY -->
		<div id="content_body">
		  <p class="page_title">Computer Work Order</p>
		  <% if Request.Form("Submit") = "Submit" then 
			set objRS = server.CreateObject("adodb.recordset")
			
			employee_name = replace(request.form("name"), "'", "''")
			problem = replace(request.form("problem"), "'", "''")
			problem = replace(problem, vbcrlf, "<br>")
			outputProblem = problem
			if request.Form("login") <> "" then
				problem = problem & "<br>Login: " & request.Form("login")
			end if
			if request.Form("password") <> "" then
				problem = problem & "<br>Password: " & request.Form("password")
			end if
			strSql = "set nocount on "
			strSql = strSql & "insert into wo (request_date,employee_name,employee_phone,problem,location,wo_type) values ("
			strSql = strSql & "'" & now() & "', "
			strSql = strSql & "'" & employee_name & "', "
			strSql = strSql & "'" & request.Form("ext") & "', "
			strSql = strSql & "'" & request.Form("location") & "', "
			strSql = strSql & "'" & problem & "', "
			strSql = strSql & "1) "
			strSql = strSql & "select last_insert_id=@@IDENTITY "
			strSql = strSql & "set nocount off"
			objRS.open strSql, objConn
			%>
			<p class='body'>The work order has been submitted, for your reference here is the information you submitted:</p>
			<table cellpadding="3" cellspacing="0" border="0" class="body">
			<tr><td>Employee:&nbsp;</td><td><%= request.Form("name") %></td></tr>
			<tr><td>Extension:&nbsp;</td><td><%= request.Form("ext") %></td></tr>
			<tr><td valign="top">Location</td><td><%= request.Form("location") %></td></tr>
			<tr><td valign="top">Description:&nbsp;</td><td><%= outputProblem %></td></tr>
			<tr><td>Work&nbsp;Order&nbsp;#:&nbsp;</td><td><%= objRS("last_insert_id") %></td></tr>
			</table>
			<p class="body"><a href="computer_work_order.asp">Click here</a> if you want to submit another Computer Work Order.</p>
			<p class="body"><a href="/">Back to CHCC Home</a></p>
		  <% else %>
		  
	      <p class="body">If you are submitting a Computer Work Order about a new hire, please use the <a href="/forms/new_hire.asp">New Hire / Replacement Request Form</a>.</p>
	      <form name="myForm" action="computer_work_order.asp" method="post" onSubmit="return isValid()">
		  <div class="body">
		  <table cellpadding="3" cellspacing="0" border="0">
		  <tr><td><span class="req">*&nbsp;</span>Name:</td><td><input type="text" name="name"></td></tr>
		  <tr><td><span class="req">*&nbsp;</span>Extension:</td><td><input type="text" name="ext"></td></tr>
		  <tr><td><span class="req">*&nbsp;</span>User Name:</td><td><input type="text" name="login"></td></tr>
		  <tr><td valign="top"><span class="req">*&nbsp;</span>Password:</td><td><input type="password" name="password"><br><font size="1">Your password will appear as *'s for safety</font></td></tr>
		  <tr><td valign="top"><span class="req">*&nbsp;</span> Location</td><td><input type="text" name="location"></td></tr>
		  <tr><td valign="top"><span class="req">*&nbsp;</span>Problem:</td><td><textarea name="problem"></textarea></td></tr>
		  <tr><td colspan="2" align="right"><input type="submit" name="Submit" value="Submit"></td></tr>
		  </table>
		  </div>
		    </form>
	      <% end if %>
		  
		</div>
		<!-- END CONTENT BODY -->
 
<!--#include virtual="/includes/asp/cms_footer.asp"-->

Open in new window

0
 
OnthraxCommented:
Sure.. what kind of field do you want to add?
0
 
b0lsc0ttIT ManagerCommented:
Also please post the ASP code if you want specific code you can use in your page to add this field.  With the html source we could just provide the results you will want to have, not the actual code to use in your page to get that html result.
bol
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

 
CHCCITAuthor Commented:
I just want to add a field that says
Location
if you need anything more or further please let me know. Thanks
0
 
CHCCITAuthor Commented:
formutils.js
/***********************************************
* Required field(s) validation v1.10- By NavSurf
* Visit Nav Surf at http://navsurf.com
* Visit http://www.dynamicdrive.com/ for full source code
***********************************************/
 
function CheckForm(formobj, fields){
	// Enter name of mandatory fields
	var fieldRequired = new Array; //("name", "LastName");
	// Enter field description to appear in the dialog box
	var fieldDescription = new Array; //("Permission Name", "Last Name");
	//alert(fields);
	fields_array = fields.split(",");
	//alert(fields_array.length);
	j = 0;
	for (i=0; i < fields_array.length; i++) {
		//alert('putting ' + fields_array[i] + ' into fieldRequired[j]');
		fieldRequired[j] = fields_array[i];
		i++;
		fieldDescription[j] = fields_array[i];
		j++;
	}
	
	/*
	for (k=0; k<j; k++) {
		alert (fieldRequired[k] + " : " + fieldDescription[k]);
	}
	*/
	
	// dialog message
	var alertMsg = "Please complete the following fields:\n\n";
	
	var l_Msg = alertMsg.length;
	
	for (var i = 0; i < fieldRequired.length; i++){
		var obj = document.myForm[fieldRequired[i]];
		// formobj.elements[fieldRequired[i]];
		if (obj){
			switch(obj.type){
			case "select-one":
				if (obj.selectedIndex == -1 || obj.options[obj.selectedIndex].text == ""){
					alertMsg += " - " + fieldDescription[i] + "\n";
				}
				break;
			case "select-multiple":
				if (obj.selectedIndex == -1){
					alertMsg += " - " + fieldDescription[i] + "\n";
				}
				break;
			case "text":
			case "textarea":
				if (obj.value == "" || obj.value == null){
					alertMsg += " - " + fieldDescription[i] + "\n";
				}
				break;
			default:
			}
			if (obj.type == undefined){
				var blnchecked = false;
				for (var j = 0; j < obj.length; j++){
					if (obj[j].checked){
						blnchecked = true;
					}
				}
				if (!blnchecked){
					alertMsg += " - " + fieldDescription[i] + "\n";
				}
			}
		}
	}
 
	if (alertMsg.length == l_Msg){
		return true;
	}else{
		alert(alertMsg);
		return false;
	}
}
 
function toggle_checkbox (checkbox)
{
	checkbox . checked = ! checkbox . checked;
}
 
 
function toggle_radio (radiobtn)
{
	radiobtn . checked = true;
}

Open in new window

0
 
b0lsc0ttConnect With a Mentor IT ManagerCommented:
Of course we need more.  Where?  What type of form field?  Those are the very least we need.  You haven't directly answered anything that was asked before.  The name is nice but not really important.  The JS code you posted, along with the screenshot and html don't directly provide much, especially if you want specific help like code.
Do you want code?  If so and you page is done in ASP, which it was in the previous question, then we need that.
Please read the comments and what we ask for carefully and respond to them.  If anything I have said or asked for isn't clear then let me know.  We still don't have anything we need to help you.
bol
0
 
CHCCITAuthor Commented:
b0lsc0tt:
I am sorry.
Here is the previous link that led me to this discussion.
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/ASP/Q_24334730.html

My Form Now has 5 fields.
I would Like to add a field called Location after the field extension.
I need this field to be a required field as all are.
I do not have and Specific requirements with this piece and may be a bit more confused as to what more is needed.

I do need Code.
And I do need more help.

Everything is done in .ASP format
If you need more please let me know and I am sorry for not be direct with exactly what I need.

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Welcome to the Christian Health Care Center Intranet</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
 
<style type="text/css" media="all"> 
   @import "/includes/css/intranet.css";
</style>
 
<link rel="stylesheet"
   type="text/css"
   media="print" href="/includes/css/intranet-print.css" />
 
<script language="javascript" src="/includes/js/open_win.js" type="text/JavaScript"></script>
 
<script language="JavaScript" type="text/JavaScript"> 
<!--
 
function preload() {
	if(document.images) {
		Open = new Image(11,11);
		Closed = new Image(11,11);
		Open.src = "/includes/images/icon_minus.gif";
		Closed.src = "/includes/images/icon_plus.gif";
	}
}
 
function showhide(menuList, menuImg) {
	if (menuList.style.display == 'none') {
		menuList.style.display='';
		menuImg.src=Open.src;
	} else {
		menuList.style.display = 'none';
		menuImg.src=Closed.src;
	}
}
 
preload();
 
 
function MM_swapImgRestore() { //v3.0
  var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}
 
function MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
 
function MM_findObj(n, d) { //v4.01
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  if(!x && d.getElementById) x=d.getElementById(n); return x;
}
 
function MM_swapImage() { //v3.0
  var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
   if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
//-->
</script>
</head>
 
<body onLoad="MM_preloadImages('/includes/images/email_on.jpg')">
<br>
<br>
<div class="content">
	<div class="content_header">
		<h2>
			<span class="content_header_left">
				<a href="/"><img src="/includes/images/logo-colored.gif" border="0"></a>
				<a href="/"><img src="/includes/images/logo-text-garamond.gif" border="0"></a>
			</span>
			<span class="content_header_right">
				<a href="http://mail.chccnj.org/exchange/" target="_blank" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('email','','/includes/images/email_on.jpg',1)">
					<img src="/includes/images/email_off.jpg" alt="Check your CHCC Email" name="email" width="60" height="47" border="0" align="right">
				</a>
			</span>
		</h2>
		<div>4/24/2009 6:49:51 PM&nbsp;&nbsp;&nbsp;</div>
	</div>
	<!-- BEGIN CONTENT MAIN -->
	<div class="content_main">
 
<!-- MENUS -->
<div id="menus">
	<div id="menus">
	<!-- all menus -->
	
<div class="menu">
	<div id="menu_Departments" class="menu_header" style="cursor:hand;" onClick="javascript:showhide(menuoutline_Departments,menusign_Departments)">
		
		<img id="menusign_Departments" src="/includes/images/icon_plus.gif" align="right" vspace="5" hspace="5">
		Departments
	</div>
	<div id="menuoutline_Departments" class="menu_body" style="display:none">
 
 
		<div class="menu_column_1">
			<ul>
	
			<li><a href="/depts/index.asp?pg_id=36" >
			
	<font color=#33660>ADS</font>
			
			</a></li>
			
     
	
 
 
	
				
	
			<li><a href="/depts/index.asp?pg_id=64" >
			
	<font color=#660066>CE</font>
			
			</a></li>
			
     
	
 
 
	
				
	
			<li><a href="/depts/index.asp?pg_id=40" >
			
	<font color=#33660>Food Services</font>
			
			</a></li>
			
     
	
 
 
	
				
	
			<li><a href="/depts/index.asp?pg_id=43" >
			
	<font color=#660066>HIM</font>
			
			</a></li>
			
     
	
 
 
	
				
	
			<li><a href="/depts/index.asp?pg_id=47" >
			
	<font color=#33660>Housekeeping</font>
			
			</a></li>
			
     
	
 
 
	
				
	
			<li><a href="/depts/index.asp?pg_id=48" >
			
	<font color=#660066>Human Resources</font>
			
			</a></li>
			
     
	
 
 
	
				
	
			<li><a href="/depts/index.asp?pg_id=51" >
			
	<font color=#33660>IT</font>
			
			</a></li>
			
     
	
 
 
	
				
	
			<li><a href="/depts/index.asp?pg_id=167" >
			
	<font color=#660066>LTC Activities</font>
			
			</a></li>
			
     
	
 
 
	
				
	
			<li><a href="/depts/index.asp?pg_id=37" >
			
	<font color=#33660>Maintenance</font>
			
			</a></li>
			
     
	
 
 
	
				
	
			</ul>
		</div>
		<div class="menu_column_2">
			<ul>
	
			<li><a href="/depts/index.asp?pg_id=55" >
			
	<font color=#660066>Marketing</font>
			
			</a></li>
			
     
	
 
 
	
				
	
			<li><a href="/depts/index.asp?pg_id=110" >
			
	<font color=#33660>ODSE</font>
			
			</a></li>
			
     
	
 
 
	
				
	
			<li><a href="/depts/index.asp?pg_id=62" >
			
	<font color=#660066>PAM</font>
			
			</a></li>
			
     
	
 
 
	
				
	
			<li><a href="/depts/index.asp?pg_id=58" >
			
	<font color=#33660>Pastoral Care</font>
			
			</a></li>
			
     
	
 
 
	
				
	
			<li><a href="/depts/index.asp?pg_id=61" >
			
	<font color=#660066>Pathways</font>
			
			</a></li>
			
     
	
 
 
	
				
	
			<li><a href="/depts/index.asp?pg_id=97" >
			
	<font color=#33660>Patient Accounting</font>
			
			</a></li>
			
     
	
 
 
	
				
	
			<li><a href="/depts/index.asp?pg_id=132" >
			
	<font color=#660066>QRS</font>
			
			</a></li>
			
     
	
 
 
	
				
	
			<li><a href="/depts/index.asp?pg_id=192" >
			
	<font color=#33660>Social Work Council</font>
			
			</a></li>
			
     
	
 
 
	
				
	
			</ul>
		</div><!-- end menu column -->
	</div><!-- end menu_body -->
</div><!-- end menu -->
<div class="spacer" style="padding:1px 0px 0px 0px;"></div>
	
<div class="menu">
	<div id="menu_Information" class="menu_header" style="cursor:hand;" onClick="javascript:showhide(menuoutline_Information,menusign_Information)">
		
		<img id="menusign_Information" src="/includes/images/icon_plus.gif" align="right" vspace="5" hspace="5">
		Information
	</div>
	<div id="menuoutline_Information" class="menu_body" style="display:none">
 
 
		<div class="menu_column_1">
			<ul>
	
			<li><a href="/info/index.asp?pg_id=112" >
			
	<font color=#33660>Annual Report Template</font>
			
			</a></li>
			
     
	
 
 
	
				
	
			<li><a href="/info/index.asp?pg_id=111" >
			
	<font color=#660066>Budget and Cost Center Codes</font>
			
			</a></li>
			
     
	
 
 
	
				
	
			<li><a href="/info/index.asp?pg_id=71" >
			
	<font color=#33660>Campus Map</font>
			
			</a></li>
			
     
	
 
 
	
				
	
	
	 
    
 
			<li><a href="\includes\pdf\acronyms.pdf" > 
			
	<font color=#660066>CHCC Acronyms</font>
		
			</a></li>
	
	
	
	
	 
    
 
			<li><a href="\docs\October Complete.pps" > 
			
	<font color=#33660>Coffee with the President</font>
		
			</a></li>
	
	
	
	
	 
    
 
			<li><a href="/forms/form.asp?fid=45" target="_blank"> 
			
	<font color=#660066>Community Benefit Inventory</font>
		
			</a></li>
	
	
	
			<li><a href="/info/index.asp?pg_id=161" >
			
	<font color=#33660>Emergency Contacts</font>
			
			</a></li>
			
     
	
 
 
	
				
	
			<li><a href="/info/index.asp?pg_id=187" >
			
	<font color=#660066>Emergency Plans</font>
			
			</a></li>
			
     
	
 
 
	
				
	
			<li><a href="/info/index.asp?pg_id=78" >
			
	<font color=#33660>Events and Happenings</font>
			
			</a></li>
			
     
	
 
 
	
				
	
			<li><a href="/info/index.asp?pg_id=68" >
			
	<font color=#660066>The Joint Commission</font>
			
			</a></li>
			
     
	
 
 
	
				
	
			<li><a href="/info/index.asp?pg_id=69" >
			
	<font color=#33660>Journey to Excellence</font>
			
			</a></li>
			
     
	
 
 
	
				
	
	
	 
    
 
			<li><a href="\docs\Management Guide.pdf" target="_blank"> 
			
	<font color=#660066>Management Guide</font>
		
			</a></li>
	
	
	
			<li><a href="/info/index.asp?pg_id=75" >
			
	<font color=#33660>Medical Formulary</font>
			
			</a></li>
			
     
	
 
 
	
				
	
			</ul>
		</div>
		<div class="menu_column_2">
			<ul>
	
	
	 
    
 
			<li><a href="/includes/pdf/MSList.pdf" target="_blank"> 
			
	<font color=#660066>Medical Staff Listing</font>
		
			</a></li>
	
	
	
	
	 
    
 
			<li><a href="http://www.state.nj.us/infobank/njzips.htm" > 
			
	<font color=#33660>New Jersey Zip Codes</font>
		
			</a></li>
	
	
	
	
	 
    
 
			<li><a href="\includes\pdf\Notification Templates.pdf" > 
			
	<font color=#660066>Notification Templates</font>
		
			</a></li>
	
	
	
			<li><a href="/info/index.asp?pg_id=79" >
			
	<font color=#33660>Organizational Charts</font>
			
			</a></li>
			
     
	
 
 
	
				
	
	
	 
    
 
			<li><a href="/includes/pdf/Overhead_Paging.pdf" > 
			
	<font color=#660066>Overhead Paging</font>
		
			</a></li>
	
	
	
			<li><a href="/info/index.asp?pg_id=199" >
			
	<font color=#33660>Policy and Procedure</font>
			
			</a></li>
			
     
	
 
 
	
				
	
			<li><a href="/info/index.asp?pg_id=146" >
			
	<font color=#660066>Recipe Cards</font>
			
			</a></li>
			
     
	
 
 
	
				
	
	
	 
    
 
			<li><a href="/info/site_map.asp" > 
			
	<font color=#33660>Site Map</font>
		
			</a></li>
	
	
	
	
	 
    
 
			<li><a href="/includes/pdf/Spirit_Path.pdf" > 
			
	<font color=#660066>Spirit Path Map</font>
		
			</a></li>
	
	
	
			<li><a href="/info/index.asp?pg_id=121" >
			
	<font color=#33660>Standing Room Only</font>
			
			</a></li>
			
     
	
 
 
	
				
	
	
	 
    
 
			<li><a href="/info/Telephone Directory 2007.pdf" > 
			
	<font color=#660066>Telephone Directory</font>
		
			</a></li>
	
	
	
			<li><a href="/info/index.asp?pg_id=185" >
			
	<font color=#33660>Uniform Code Unity</font>
			
			</a></li>
			
     
	
 
 
	
				
	
			</ul>
		</div><!-- end menu column -->
	</div><!-- end menu_body -->
</div><!-- end menu -->
<div class="spacer" style="padding:1px 0px 0px 0px;"></div>
	
<div class="menu">
	<div id="menu_Services" class="menu_header" style="cursor:hand;" onClick="javascript:showhide(menuoutline_Services,menusign_Services)">
		
		<img id="menusign_Services" src="/includes/images/icon_plus.gif" align="right" vspace="5" hspace="5">
		Services
	</div>
	<div id="menuoutline_Services" class="menu_body" style="display:none">
 
 
		<div class="menu_column_1">
			<ul>
	
	
	 
    
 
			<li><a href="http://server18/wfc/logon" target="_blank"> 
			
	<font color=#33660>ADP Enterprise E-time</font>
		
			</a></li>
	
	
	
	
	 
    
 
			<li><a href="http://ampweb.chcc" target="_blank"> 
			
	<font color=#660066>AMP</font>
		
			</a></li>
	
	
	
	
	 
    
 
			<li><a href="http://67.90.56.98/facilitylink2" target="_blank"> 
			
	<font color=#33660>ChemRx Facility Link </font>
		
			</a></li>
	
	
	
	
	 
    
 
			<li><a href="/forms/form.asp?fid=32" > 
			
	<font color=#660066>Computer Registration</font>
		
			</a></li>
	
	
	
	
	 
    
 
			<li><a href="/forms/contractor/" > 
			
	<font color=#33660>Contractor / Vendor Sign-In</font>
		
			</a></li>
	
	
	
	
	 
    
 
			<li><a href="http://server5/dwis3/cgi/dwis.pl" > 
			
	<font color=#660066>DocuWare</font>
		
			</a></li>
	
	
	
			<li><a href="/services/index.asp?pg_id=169" >
			
	<font color=#33660>Downloadable Forms</font>
			
			</a></li>
			
     
	
 
 
	
				
	
			<li><a href="/services/index.asp?pg_id=196" >
			
	<font color=#660066>Educational Opportunities</font>
			
			</a></li>
			
     
	
 
 
	
				
	
	
	 
    
 
			<li><a href="https://trakstar.promantek.com/" > 
			
	<font color=#33660>Evaluation</font>
		
			</a></li>
	
	
	
			<li><a href="/services/index.asp?pg_id=82" >
			
	<font color=#660066>Healthcare & Medical Library</font>
			
			</a></li>
			
     
	
 
 
	
				
	
	
	 
    
 
			<li><a href="/forms/form.asp?fid=34" > 
			
	<font color=#33660>Insurance Form</font>
		
			</a></li>
	
	
	
	
	 
    
 
			<li><a href="http://server1/web/base/callerlogindisp?tenant=PRD" target="_blank"> 
			
	<font color=#660066>Maintenance Work Order</font>
		
			</a></li>
	
	
	
	
	 
    
 
			<li><a href="/depts/index.asp?pg_id=51" > 
			
	<font color=#33660>IT Work Orders</font>
		
			</a></li>
	
	
	
			<li><a href="/services/index.asp?pg_id=145" >
			
	<font color=#660066>Medicare D - PDP</font>
			
			</a></li>
			
     
	
 
 
	
				
	
	
	 
    
 
			<li><a href="https://support.mobilexusa.com/mxlive/Default.aspx" target="_blank"> 
			
	<font color=#33660>Mobilex</font>
		
			</a></li>
	
	
	
			</ul>
		</div>
		<div class="menu_column_2">
			<ul>
	
			<li><a href="/services/index.asp?pg_id=166" >
			
	<font color=#660066>MSDS</font>
			
			</a></li>
			
     
	
 
 
	
				
	
	
	 
    
 
			<li><a href="/forms/new_hire.asp" > 
			
	<font color=#33660>New Hire/Status Change</font>
		
			</a></li>
	
	
	
	
	 
    
 
			<li><a href="http://server3/rmweb3/riskweb3.dll/FrmLogin" > 
			
	<font color=#660066>Occurrence Reporting</font>
		
			</a></li>
	
	
	
			<li><a href="/services/index.asp?pg_id=189" >
			
	<font color=#33660>Orientation Checklists</font>
			
			</a></li>
			
     
	
 
 
	
				
	
	
	 
    
 
			<li><a href="/forms/rnc.asp" > 
			
	<font color=#660066>RNC Form</font>
		
			</a></li>
	
	
	
			<li><a href="/services/index.asp?pg_id=191" >
			
	<font color=#33660>SigmaCare</font>
			
			</a></li>
			
     
	
 
 
	
				
	
			<li><a href="/services/index.asp?pg_id=86" >
			
	<font color=#660066>Special Event Reservation</font>
			
			</a></li>
			
     
	
 
 
	
				
	
	
	 
    
 
			<li><a href="/forms/form.asp?fid=25" > 
			
	<font color=#33660>Storage Request</font>
		
			</a></li>
	
	
	
	
	 
    
 
			<li><a href="/forms/form.asp?fid=41" > 
			
	<font color=#660066>Thank-You Cards</font>
		
			</a></li>
	
	
	
	
	 
    
 
			<li><a href="/forms/tracking_referral.asp" > 
			
	<font color=#33660>Tracking Referrals</font>
		
			</a></li>
	
	
	
			<li><a href="/services/index.asp?pg_id=89" >
			
	<font color=#660066>Transportation Scheduling</font>
			
			</a></li>
			
     
	
 
 
	
				
	
	
	 
    
 
			<li><a href="/forms/form.asp?fid=33" > 
			
	<font color=#33660>Travel Requisition</font>
		
			</a></li>
	
	
	
	
	 
    
 
			<li><a href="http://www.yellowpages.com" target="_blank"> 
			
	<font color=#660066>YellowPages.com</font>
		
			</a></li>
	
	
	
	
	 
    
 
			<li><a href="http://server21/winscribetext/portal/" > 
			
	<font color=#33660>Winscribe</font>
		
			</a></li>
	
	
	
	
	 
    
 
			<li><a href="\includes\pdf\WB Mason Order Form.pdf" > 
			
	<font color=#660066>WB Mason Order Form</font>
		
			</a></li>
	
	
	
 
			</ul>
		</div>
	</div>
</div>
<div class="spacer" style="padding:1px 0px 0px 0px;"></div>
 
	<!-- THOUGHT OF THE WEEK -->
	<div class="menu">
	<div class="menu_header">Thought of the Week</div>
	<div class="menu_body_totw">
		<br>
		<!-- Query from DB -->
		"Now let the heavens be joyful, let earth her song begin; let the round world keep triumph, and all that is therein; let all things seen and unseen their notes of gladness blend, for Christ the Lord hath risen, our joy that knows no end."<br>   -John of Damascus;tr.J.M.Neale,1862<br>
		<br>&nbsp;
	</div>
</div>
	<!-- END THOUGHT OF THE WEEK -->
	<!-- MISSION STATEMENT -->
	<div class="menu">
	<div class="menu_header">About CHCC</div>
	<div class="menu_body" style="background: url('/includes/images/menu-hands-background.gif') no-repeat center right;">
		<br>
		<p style="padding: 0px 0px 0px 5px;"><font size="1">Christian Health Care Center was founded in 1911 by a group of 
		deacons from local Reformed and Christian Reformed Churches. Today, CHCC - a 
		non-profit organization open to anyone regardless of race, sex, or religion - 
		provides a continuum of high-quality, family-centered elder-care and mental-health 
		services in a compassionate and loving environment consistent with the Christian 
		principles on which the institution was founded.</font></p>
		<p align="center"><font size="1"><a href="#" onclick="javascript:window.open('/includes/asp/mission.asp', 'Mission', 'width=350,height=350,scrollbars=yes,resize=yes');">Mission Statement and Vision</a></font></p>
	</div>
</div>
	<!-- END MISSION STATEMENT -->
	</div>
</div>
<!-- END MENUS -->
 
<script language="javascript" src="/includes/js/formutils.js" type="text/javascript"></script>
<script language="JavaScript">
 
function isValid() {
  with (document.myForm) {
     if (name.value =="") { // check For First Name
    alert("ATTENTION\n\n\n..\nName is required.\n..\n\n\n");
    name.focus();
	return false;
   }      
   if (ext.value =="") { // check For extention
    alert("ATTENTION!\n\n\n..\nExtension is required.\n..\n\n\n");
    ext.focus();
	return false;
   } 
   if (login.value =="") { // check Login is required.\n..\n\n\n");
    alert("ATTENTION\n\n\n..\nNetwork Credentials Required.\n..\n\n\n");
    login.focus();
	return false;
   }  
   if (password.value =="") { // check For Passord
    alert("ATTENTION\n\n\n..\nNetwork Password is required.\n..\n\n\n");
    password.focus();
	return false;
   }
   if (problem.value =="") { // check For problem
    alert("ATTENTION\n\n\n..\nproblem is required.\n..\n\n\n");
    problem.focus();
	return false;
   }  
 
 }
 return true;
}
    </script> 
<!-- BEGIN CONTENT BODY -->
		<div id="content_body">
		  <p class="page_title">Computer Work Order</p>
		  
		  
	      <p class="body">If you are submitting a Computer Work Order about a new hire, please use the <a href="/forms/new_hire.asp">New Hire / Replacement Request Form</a>.</p>
	      <form name="myForm" action="computer_work_order.asp" method="post" onSubmit="return isValid()">
		  <div class="body">
		  <table cellpadding="3" cellspacing="0" border="0">
		  <tr><td><span class="req">*&nbsp;</span>Name:</td><td><input type="text" name="name"></td></tr>
		  <tr><td><span class="req">*&nbsp;</span>Extension:</td><td><input type="text" name="ext"></td></tr>
		  <tr><td><span class="req">*&nbsp;</span>User Name:</td><td><input type="text" name="login"></td></tr>
		  <tr><td valign="top"><span class="req">*&nbsp;</span>Password:</td><td><input type="password" name="password"><br><font size="1">Your password will appear as *'s for safety</font></td></tr>
		  <tr><td valign="top"><span class="req">*&nbsp;</span>Problem:</td><td><textarea name="problem"></textarea></td></tr>
		  <tr><td colspan="2" align="right"><input type="submit" name="Submit" value="Submit"></td></tr>
		  </table>
		  </div>
		    </form>
	      
		  
		</div>
		<!-- END CONTENT BODY -->
 
	<div class="spacer"></div>
	</div><!-- END CONTENT MAIN -->
</div><!-- END CONTENT -->
<!-- COPYRIGHT INFO -->
<div class="spacer"></div>
<div class="footer" align="center">Copyright &copy; Christian Health Care Center. All rights reserved.</div>
<div class="spacer"></div>
</body>
</html>

Open in new window

computer-work-order.txt
0
 
CHCCITAuthor Commented:
b0lsc0tt:

Is there something more that I am missing. I am trying to figure out if I answered everything for you correctly in hopes of moving on if not please let me know thanks
0
 
Kalpana_NatarajanCommented:
Hi,

The easier way is to have hidden fields, in your form... and set them to visible based on the event at which you want the fields to be added.

Regards,
Kalpana
0
 
Kalpana_NatarajanCommented:
Hi,

The easier way is to have hidden fields, in your form... and set them to visible based on the event at which you want the fields to be added.

Regards,
Kalpana
0
 
CHCCITAuthor Commented:
Thanks for the info Kalpana, But I am not sure how to do this as I am editing code that I did not do, This is something I am taking over for my last web guy and I am doing clean up.

0
 
Mark WoodNetwork AdministratorCommented:
I added the location field to your form but you still need to add a field to your database named location and edit your computer_work_order.asp file so that it inserts the contents of that field into the database.

If you need help with this let me know.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Welcome to the Christian Health Care Center Intranet</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
 
<style type="text/css" media="all"> 
   @import "/includes/css/intranet.css";
</style>
 
<link rel="stylesheet"
   type="text/css"
   media="print" href="/includes/css/intranet-print.css" />
 
<script language="javascript" src="/includes/js/open_win.js" type="text/JavaScript"></script>
 
<script language="JavaScript" type="text/JavaScript"> 
<!--
 
function preload() {
	if(document.images) {
		Open = new Image(11,11);
		Closed = new Image(11,11);
		Open.src = "/includes/images/icon_minus.gif";
		Closed.src = "/includes/images/icon_plus.gif";
	}
}
 
function showhide(menuList, menuImg) {
	if (menuList.style.display == 'none') {
		menuList.style.display='';
		menuImg.src=Open.src;
	} else {
		menuList.style.display = 'none';
		menuImg.src=Closed.src;
	}
}
 
preload();
 
 
function MM_swapImgRestore() { //v3.0
  var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}
 
function MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
 
function MM_findObj(n, d) { //v4.01
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  if(!x && d.getElementById) x=d.getElementById(n); return x;
}
 
function MM_swapImage() { //v3.0
  var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
   if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
//-->
</script>
</head>
 
<body onLoad="MM_preloadImages('/includes/images/email_on.jpg')">
<br>
<br>
<div class="content">
	<div class="content_header">
		<h2>
			<span class="content_header_left">
				<a href="/"><img src="/includes/images/logo-colored.gif" border="0"></a>
				<a href="/"><img src="/includes/images/logo-text-garamond.gif" border="0"></a>
			</span>
			<span class="content_header_right">
				<a href="http://mail.chccnj.org/exchange/" target="_blank" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('email','','/includes/images/email_on.jpg',1)">
					<img src="/includes/images/email_off.jpg" alt="Check your CHCC Email" name="email" width="60" height="47" border="0" align="right">
				</a>
			</span>
		</h2>
		<div>4/24/2009 6:49:51 PM&nbsp;&nbsp;&nbsp;</div>
	</div>
	<!-- BEGIN CONTENT MAIN -->
	<div class="content_main">
 
<!-- MENUS -->
<div id="menus">
	<div id="menus">
	<!-- all menus -->
	
<div class="menu">
	<div id="menu_Departments" class="menu_header" style="cursor:hand;" onClick="javascript:showhide(menuoutline_Departments,menusign_Departments)">
		
		<img id="menusign_Departments" src="/includes/images/icon_plus.gif" align="right" vspace="5" hspace="5">
		Departments
	</div>
	<div id="menuoutline_Departments" class="menu_body" style="display:none">
 
 
		<div class="menu_column_1">
			<ul>
	
			<li><a href="/depts/index.asp?pg_id=36" >
			
	<font color=#33660>ADS</font>
			
			</a></li>
			
     
	
 
 
	
				
	
			<li><a href="/depts/index.asp?pg_id=64" >
			
	<font color=#660066>CE</font>
			
			</a></li>
			
     
	
 
 
	
				
	
			<li><a href="/depts/index.asp?pg_id=40" >
			
	<font color=#33660>Food Services</font>
			
			</a></li>
			
     
	
 
 
	
				
	
			<li><a href="/depts/index.asp?pg_id=43" >
			
	<font color=#660066>HIM</font>
			
			</a></li>
			
     
	
 
 
	
				
	
			<li><a href="/depts/index.asp?pg_id=47" >
			
	<font color=#33660>Housekeeping</font>
			
			</a></li>
			
     
	
 
 
	
				
	
			<li><a href="/depts/index.asp?pg_id=48" >
			
	<font color=#660066>Human Resources</font>
			
			</a></li>
			
     
	
 
 
	
				
	
			<li><a href="/depts/index.asp?pg_id=51" >
			
	<font color=#33660>IT</font>
			
			</a></li>
			
     
	
 
 
	
				
	
			<li><a href="/depts/index.asp?pg_id=167" >
			
	<font color=#660066>LTC Activities</font>
			
			</a></li>
			
     
	
 
 
	
				
	
			<li><a href="/depts/index.asp?pg_id=37" >
			
	<font color=#33660>Maintenance</font>
			
			</a></li>
			
     
	
 
 
	
				
	
			</ul>
		</div>
		<div class="menu_column_2">
			<ul>
	
			<li><a href="/depts/index.asp?pg_id=55" >
			
	<font color=#660066>Marketing</font>
			
			</a></li>
			
     
	
 
 
	
				
	
			<li><a href="/depts/index.asp?pg_id=110" >
			
	<font color=#33660>ODSE</font>
			
			</a></li>
			
     
	
 
 
	
				
	
			<li><a href="/depts/index.asp?pg_id=62" >
			
	<font color=#660066>PAM</font>
			
			</a></li>
			
     
	
 
 
	
				
	
			<li><a href="/depts/index.asp?pg_id=58" >
			
	<font color=#33660>Pastoral Care</font>
			
			</a></li>
			
     
	
 
 
	
				
	
			<li><a href="/depts/index.asp?pg_id=61" >
			
	<font color=#660066>Pathways</font>
			
			</a></li>
			
     
	
 
 
	
				
	
			<li><a href="/depts/index.asp?pg_id=97" >
			
	<font color=#33660>Patient Accounting</font>
			
			</a></li>
			
     
	
 
 
	
				
	
			<li><a href="/depts/index.asp?pg_id=132" >
			
	<font color=#660066>QRS</font>
			
			</a></li>
			
     
	
 
 
	
				
	
			<li><a href="/depts/index.asp?pg_id=192" >
			
	<font color=#33660>Social Work Council</font>
			
			</a></li>
			
     
	
 
 
	
				
	
			</ul>
		</div><!-- end menu column -->
	</div><!-- end menu_body -->
</div><!-- end menu -->
<div class="spacer" style="padding:1px 0px 0px 0px;"></div>
	
<div class="menu">
	<div id="menu_Information" class="menu_header" style="cursor:hand;" onClick="javascript:showhide(menuoutline_Information,menusign_Information)">
		
		<img id="menusign_Information" src="/includes/images/icon_plus.gif" align="right" vspace="5" hspace="5">
		Information
	</div>
	<div id="menuoutline_Information" class="menu_body" style="display:none">
 
 
		<div class="menu_column_1">
			<ul>
	
			<li><a href="/info/index.asp?pg_id=112" >
			
	<font color=#33660>Annual Report Template</font>
			
			</a></li>
			
     
	
 
 
	
				
	
			<li><a href="/info/index.asp?pg_id=111" >
			
	<font color=#660066>Budget and Cost Center Codes</font>
			
			</a></li>
			
     
	
 
 
	
				
	
			<li><a href="/info/index.asp?pg_id=71" >
			
	<font color=#33660>Campus Map</font>
			
			</a></li>
			
     
	
 
 
	
				
	
	
	 
    
 
			<li><a href="\includes\pdf\acronyms.pdf" > 
			
	<font color=#660066>CHCC Acronyms</font>
		
			</a></li>
	
	
	
	
	 
    
 
			<li><a href="\docs\October Complete.pps" > 
			
	<font color=#33660>Coffee with the President</font>
		
			</a></li>
	
	
	
	
	 
    
 
			<li><a href="/forms/form.asp?fid=45" target="_blank"> 
			
	<font color=#660066>Community Benefit Inventory</font>
		
			</a></li>
	
	
	
			<li><a href="/info/index.asp?pg_id=161" >
			
	<font color=#33660>Emergency Contacts</font>
			
			</a></li>
			
     
	
 
 
	
				
	
			<li><a href="/info/index.asp?pg_id=187" >
			
	<font color=#660066>Emergency Plans</font>
			
			</a></li>
			
     
	
 
 
	
				
	
			<li><a href="/info/index.asp?pg_id=78" >
			
	<font color=#33660>Events and Happenings</font>
			
			</a></li>
			
     
	
 
 
	
				
	
			<li><a href="/info/index.asp?pg_id=68" >
			
	<font color=#660066>The Joint Commission</font>
			
			</a></li>
			
     
	
 
 
	
				
	
			<li><a href="/info/index.asp?pg_id=69" >
			
	<font color=#33660>Journey to Excellence</font>
			
			</a></li>
			
     
	
 
 
	
				
	
	
	 
    
 
			<li><a href="\docs\Management Guide.pdf" target="_blank"> 
			
	<font color=#660066>Management Guide</font>
		
			</a></li>
	
	
	
			<li><a href="/info/index.asp?pg_id=75" >
			
	<font color=#33660>Medical Formulary</font>
			
			</a></li>
			
     
	
 
 
	
				
	
			</ul>
		</div>
		<div class="menu_column_2">
			<ul>
	
	
	 
    
 
			<li><a href="/includes/pdf/MSList.pdf" target="_blank"> 
			
	<font color=#660066>Medical Staff Listing</font>
		
			</a></li>
	
	
	
	
	 
    
 
			<li><a href="http://www.state.nj.us/infobank/njzips.htm" > 
			
	<font color=#33660>New Jersey Zip Codes</font>
		
			</a></li>
	
	
	
	
	 
    
 
			<li><a href="\includes\pdf\Notification Templates.pdf" > 
			
	<font color=#660066>Notification Templates</font>
		
			</a></li>
	
	
	
			<li><a href="/info/index.asp?pg_id=79" >
			
	<font color=#33660>Organizational Charts</font>
			
			</a></li>
			
     
	
 
 
	
				
	
	
	 
    
 
			<li><a href="/includes/pdf/Overhead_Paging.pdf" > 
			
	<font color=#660066>Overhead Paging</font>
		
			</a></li>
	
	
	
			<li><a href="/info/index.asp?pg_id=199" >
			
	<font color=#33660>Policy and Procedure</font>
			
			</a></li>
			
     
	
 
 
	
				
	
			<li><a href="/info/index.asp?pg_id=146" >
			
	<font color=#660066>Recipe Cards</font>
			
			</a></li>
			
     
	
 
 
	
				
	
	
	 
    
 
			<li><a href="/info/site_map.asp" > 
			
	<font color=#33660>Site Map</font>
		
			</a></li>
	
	
	
	
	 
    
 
			<li><a href="/includes/pdf/Spirit_Path.pdf" > 
			
	<font color=#660066>Spirit Path Map</font>
		
			</a></li>
	
	
	
			<li><a href="/info/index.asp?pg_id=121" >
			
	<font color=#33660>Standing Room Only</font>
			
			</a></li>
			
     
	
 
 
	
				
	
	
	 
    
 
			<li><a href="/info/Telephone Directory 2007.pdf" > 
			
	<font color=#660066>Telephone Directory</font>
		
			</a></li>
	
	
	
			<li><a href="/info/index.asp?pg_id=185" >
			
	<font color=#33660>Uniform Code Unity</font>
			
			</a></li>
			
     
	
 
 
	
				
	
			</ul>
		</div><!-- end menu column -->
	</div><!-- end menu_body -->
</div><!-- end menu -->
<div class="spacer" style="padding:1px 0px 0px 0px;"></div>
	
<div class="menu">
	<div id="menu_Services" class="menu_header" style="cursor:hand;" onClick="javascript:showhide(menuoutline_Services,menusign_Services)">
		
		<img id="menusign_Services" src="/includes/images/icon_plus.gif" align="right" vspace="5" hspace="5">
		Services
	</div>
	<div id="menuoutline_Services" class="menu_body" style="display:none">
 
 
		<div class="menu_column_1">
			<ul>
	
	
	 
    
 
			<li><a href="http://server18/wfc/logon" target="_blank"> 
			
	<font color=#33660>ADP Enterprise E-time</font>
		
			</a></li>
	
	
	
	
	 
    
 
			<li><a href="http://ampweb.chcc" target="_blank"> 
			
	<font color=#660066>AMP</font>
		
			</a></li>
	
	
	
	
	 
    
 
			<li><a href="http://67.90.56.98/facilitylink2" target="_blank"> 
			
	<font color=#33660>ChemRx Facility Link </font>
		
			</a></li>
	
	
	
	
	 
    
 
			<li><a href="/forms/form.asp?fid=32" > 
			
	<font color=#660066>Computer Registration</font>
		
			</a></li>
	
	
	
	
	 
    
 
			<li><a href="/forms/contractor/" > 
			
	<font color=#33660>Contractor / Vendor Sign-In</font>
		
			</a></li>
	
	
	
	
	 
    
 
			<li><a href="http://server5/dwis3/cgi/dwis.pl" > 
			
	<font color=#660066>DocuWare</font>
		
			</a></li>
	
	
	
			<li><a href="/services/index.asp?pg_id=169" >
			
	<font color=#33660>Downloadable Forms</font>
			
			</a></li>
			
     
	
 
 
	
				
	
			<li><a href="/services/index.asp?pg_id=196" >
			
	<font color=#660066>Educational Opportunities</font>
			
			</a></li>
			
     
	
 
 
	
				
	
	
	 
    
 
			<li><a href="https://trakstar.promantek.com/" > 
			
	<font color=#33660>Evaluation</font>
		
			</a></li>
	
	
	
			<li><a href="/services/index.asp?pg_id=82" >
			
	<font color=#660066>Healthcare &amp; Medical Library</font>
			
			</a></li>
			
     
	
 
 
	
				
	
	
	 
    
 
			<li><a href="/forms/form.asp?fid=34" > 
			
	<font color=#33660>Insurance Form</font>
		
			</a></li>
	
	
	
	
	 
    
 
			<li><a href="http://server1/web/base/callerlogindisp?tenant=PRD" target="_blank"> 
			
	<font color=#660066>Maintenance Work Order</font>
		
			</a></li>
	
	
	
	
	 
    
 
			<li><a href="/depts/index.asp?pg_id=51" > 
			
	<font color=#33660>IT Work Orders</font>
		
			</a></li>
	
	
	
			<li><a href="/services/index.asp?pg_id=145" >
			
	<font color=#660066>Medicare D - PDP</font>
			
			</a></li>
			
     
	
 
 
	
				
	
	
	 
    
 
			<li><a href="https://support.mobilexusa.com/mxlive/Default.aspx" target="_blank"> 
			
	<font color=#33660>Mobilex</font>
		
			</a></li>
	
	
	
			</ul>
		</div>
		<div class="menu_column_2">
			<ul>
	
			<li><a href="/services/index.asp?pg_id=166" >
			
	<font color=#660066>MSDS</font>
			
			</a></li>
			
     
	
 
 
	
				
	
	
	 
    
 
			<li><a href="/forms/new_hire.asp" > 
			
	<font color=#33660>New Hire/Status Change</font>
		
			</a></li>
	
	
	
	
	 
    
 
			<li><a href="http://server3/rmweb3/riskweb3.dll/FrmLogin" > 
			
	<font color=#660066>Occurrence Reporting</font>
		
			</a></li>
	
	
	
			<li><a href="/services/index.asp?pg_id=189" >
			
	<font color=#33660>Orientation Checklists</font>
			
			</a></li>
			
     
	
 
 
	
				
	
	
	 
    
 
			<li><a href="/forms/rnc.asp" > 
			
	<font color=#660066>RNC Form</font>
		
			</a></li>
	
	
	
			<li><a href="/services/index.asp?pg_id=191" >
			
	<font color=#33660>SigmaCare</font>
			
			</a></li>
			
     
	
 
 
	
				
	
			<li><a href="/services/index.asp?pg_id=86" >
			
	<font color=#660066>Special Event Reservation</font>
			
			</a></li>
			
     
	
 
 
	
				
	
	
	 
    
 
			<li><a href="/forms/form.asp?fid=25" > 
			
	<font color=#33660>Storage Request</font>
		
			</a></li>
	
	
	
	
	 
    
 
			<li><a href="/forms/form.asp?fid=41" > 
			
	<font color=#660066>Thank-You Cards</font>
		
			</a></li>
	
	
	
	
	 
    
 
			<li><a href="/forms/tracking_referral.asp" > 
			
	<font color=#33660>Tracking Referrals</font>
		
			</a></li>
	
	
	
			<li><a href="/services/index.asp?pg_id=89" >
			
	<font color=#660066>Transportation Scheduling</font>
			
			</a></li>
			
     
	
 
 
	
				
	
	
	 
    
 
			<li><a href="/forms/form.asp?fid=33" > 
			
	<font color=#33660>Travel Requisition</font>
		
			</a></li>
	
	
	
	
	 
    
 
			<li><a href="http://www.yellowpages.com" target="_blank"> 
			
	<font color=#660066>YellowPages.com</font>
		
			</a></li>
	
	
	
	
	 
    
 
			<li><a href="http://server21/winscribetext/portal/" > 
			
	<font color=#33660>Winscribe</font>
		
			</a></li>
	
	
	
	
	 
    
 
			<li><a href="\includes\pdf\WB Mason Order Form.pdf" > 
			
	<font color=#660066>WB Mason Order Form</font>
		
			</a></li>
	
	
	
 
			</ul>
		</div>
	</div>
</div>
<div class="spacer" style="padding:1px 0px 0px 0px;"></div>
 
	<!-- THOUGHT OF THE WEEK -->
	<div class="menu">
	<div class="menu_header">Thought of the Week</div>
	<div class="menu_body_totw">
		<br>
		<!-- Query from DB -->
		&quot;Now let the heavens be joyful, let earth her song begin; let the round 
		world keep triumph, and all that is therein; let all things seen and 
		unseen their notes of gladness blend, for Christ the Lord hath risen, 
		our joy that knows no end.&quot;<br>   -John of Damascus;tr.J.M.Neale,1862<br>
		<br>&nbsp;
	</div>
</div>
	<!-- END THOUGHT OF THE WEEK -->
	<!-- MISSION STATEMENT -->
	<div class="menu">
	<div class="menu_header">About CHCC</div>
	<div class="menu_body" style="background: url('/includes/images/menu-hands-background.gif') no-repeat center right;">
		<br>
		<p style="padding: 0px 0px 0px 5px;"><font size="1">Christian Health 
		Care Center was founded in 1911 by a group of deacons from local 
		Reformed and Christian Reformed Churches. Today, CHCC - a non-profit 
		organization open to anyone regardless of race, sex, or religion - 
		provides a continuum of high-quality, family-centered elder-care and 
		mental-health services in a compassionate and loving environment 
		consistent with the Christian principles on which the institution was 
		founded.</font></p>
		<p align="center"><font size="1"><a href="#" onclick="javascript:window.open('/includes/asp/mission.asp', 'Mission', 'width=350,height=350,scrollbars=yes,resize=yes');">
		Mission Statement and Vision</a></font></p>
	</div>
</div>
	<!-- END MISSION STATEMENT -->
	</div>
</div>
<!-- END MENUS -->
 
<script language="javascript" src="/includes/js/formutils.js" type="text/javascript"></script>
<script language="JavaScript">
 
function isValid() {
  with (document.myForm) {
     if (name.value =="") { // check For First Name
    alert("ATTENTION\n\n\n..\nName is required.\n..\n\n\n");
    name.focus();
	return false;
   }      
   if (ext.value =="") { // check For extention
    alert("ATTENTION!\n\n\n..\nExtension is required.\n..\n\n\n");
    ext.focus();
	return false;
   } 
   if (login.value =="") { // check Login is required.\n..\n\n\n");
    alert("ATTENTION\n\n\n..\nNetwork Credentials Required.\n..\n\n\n");
    login.focus();
	return false;
   }  
   if (password.value =="") { // check For Passord
    alert("ATTENTION\n\n\n..\nNetwork Password is required.\n..\n\n\n");
    password.focus();
	return false;
   }
   if (problem.value =="") { // check For problem
    alert("ATTENTION\n\n\n..\nproblem is required.\n..\n\n\n");
    problem.focus();
	return false;
   }  
 
 }
 return true;
}
    </script> 
<!-- BEGIN CONTENT BODY -->
		<div id="content_body">
		  <p class="page_title">Computer Work Order</p>
		  
		  
	      <p class="body">If you are submitting a Computer Work Order about a 
			new hire, please use the <a href="/forms/new_hire.asp">New Hire / 
			Replacement Request Form</a>.</p>
	      <form name="myForm" action="computer_work_order.asp" method="post" onSubmit="return isValid()">
		  <div class="body">
		  <table cellpadding="3" cellspacing="0" border="0">
		  <tr><td><span class="req">*&nbsp;</span>Name:</td><td><input type="text" name="name"></td></tr>
		  <tr><td><span class="req">*&nbsp;</span>Extension:</td><td><input type="text" name="ext"></td></tr>
		  <tr><td><span class="req">*&nbsp;</span>User Name:</td><td><input type="text" name="login"></td></tr>
		  <tr><td valign="top"><span class="req">*&nbsp;</span>Password:</td><td><input type="password" name="password"><br><font size="1">
			Your password will appear as *'s for safety</font></td></tr>
		  <tr><td valign="top">*Location</td><td>
			<input type="text" name="location" size="20"></td></tr>
		  <tr><td valign="top"><span class="req">*&nbsp;</span>Problem:</td><td><textarea name="problem"></textarea></td></tr>
		  <tr><td colspan="2" align="right"><input type="submit" name="Submit" value="Submit"></td></tr>
		  </table>
		  </div>
		    </form>
	      
		  
		</div>
		<!-- END CONTENT BODY -->
 
	<div class="spacer"></div>
	</div><!-- END CONTENT MAIN -->
</div><!-- END CONTENT -->
<!-- COPYRIGHT INFO -->
<div class="spacer"></div>
<div class="footer" align="center">Copyright © Christian Health Care Center. All 
	rights reserved.</div>
<div class="spacer"></div>
</body>
</html>  

Open in new window

0
 
CHCCITAuthor Commented:
Mrwood 6275

Thanks for the Code.

I may need some advise on adding this into my database but I will see how it works out first then I will take it from there. I appreciate your help thanks
0
 
CHCCITAuthor Commented:
Can I get the exact edits for below.
I am also checking my SQL Database titles intranet and looking for the field to add. Thanks
<!--#include virtual="/includes/asp/cms_header.asp"-->
 
<!-- MENUS -->
<!--#include virtual="/includes/asp/cms_right_menu.asp"-->
<!-- END MENUS -->
 
<script language="javascript" src="/includes/js/formutils.js" type="text/javascript"></script>
<script language="JavaScript">
 
function isValid() {
  with (document.myForm) {
     if (name.value =="") { // check For First Name
    alert("ATTENTION\n\n\n..\nName is required.\n..\n\n\n");
    name.focus();
	return false;
   }      
   if (ext.value =="") { // check For extention
    alert("ATTENTION!\n\n\n..\nExtension is required.\n..\n\n\n");
    ext.focus();
	return false;
   } 
   if (login.value =="") { // check Login is required.\n..\n\n\n");
    alert("ATTENTION\n\n\n..\nNetwork Credentials Required.\n..\n\n\n");
    login.focus();
	return false;
   }  
   if (password.value =="") { // check For Passord
    alert("ATTENTION\n\n\n..\nNetwork Password is required.\n..\n\n\n");
    password.focus();
	return false;
   }
   if (problem.value =="") { // check For problem
    alert("ATTENTION\n\n\n..\nproblem is required.\n..\n\n\n");
    problem.focus();
	return false;
   }  
 
 }
 return true;
}
    </script> 
<!-- BEGIN CONTENT BODY -->
		<div id="content_body">
		  <p class="page_title">Computer Work Order</p>
		  <% if Request.Form("Submit") = "Submit" then 
			set objRS = server.CreateObject("adodb.recordset")
			
			employee_name = replace(request.form("name"), "'", "''")
			problem = replace(request.form("problem"), "'", "''")
			problem = replace(problem, vbcrlf, "<br>")
			outputProblem = problem
			if request.Form("login") <> "" then
				problem = problem & "<br>Login: " & request.Form("login")
			end if
			if request.Form("password") <> "" then
				problem = problem & "<br>Password: " & request.Form("password")
			end if
			strSql = "set nocount on "
			strSql = strSql & "insert into wo (request_date,employee_name,employee_phone,problem,wo_type) values ("
			strSql = strSql & "'" & now() & "', "
			strSql = strSql & "'" & employee_name & "', "
			strSql = strSql & "'" & request.Form("ext") & "', "
			strSql = strSql & "'" & problem & "', "
			strSql = strSql & "1) "
			strSql = strSql & "select last_insert_id=@@IDENTITY "
			strSql = strSql & "set nocount off"
			objRS.open strSql, objConn
			%>
			<p class='body'>The work order has been submitted, for your reference here is the information you submitted:</p>
			<table cellpadding="3" cellspacing="0" border="0" class="body">
			<tr><td>Employee:&nbsp;</td><td><%= request.Form("name") %></td></tr>
			<tr><td>Extension:&nbsp;</td><td><%= request.Form("ext") %></td></tr>
			<tr><td valign="top">Description:&nbsp;</td><td><%= outputProblem %></td></tr>
			<tr><td>Work&nbsp;Order&nbsp;#:&nbsp;</td><td><%= objRS("last_insert_id") %></td></tr>
			</table>
			<p class="body"><a href="computer_work_order.asp">Click here</a> if you want to submit another Computer Work Order.</p>
			<p class="body"><a href="/">Back to CHCC Home</a></p>
		  <% else %>
		  
	      <p class="body">If you are submitting a Computer Work Order about a new hire, please use the <a href="/forms/new_hire.asp">New Hire / Replacement Request Form</a>.</p>
	      <form name="myForm" action="computer_work_order.asp" method="post" onSubmit="return isValid()">
		  <div class="body">
		  <table cellpadding="3" cellspacing="0" border="0">
		  <tr><td><span class="req">*&nbsp;</span>Name:</td><td><input type="text" name="name"></td></tr>
		  <tr><td><span class="req">*&nbsp;</span>Extension:</td><td><input type="text" name="ext"></td></tr>
		  <tr><td><span class="req">*&nbsp;</span>User Name:</td><td><input type="text" name="login"></td></tr>
		  <tr><td valign="top"><span class="req">*&nbsp;</span>Password:</td><td><input type="password" name="password"><br><font size="1">Your password will appear as *'s for safety</font></td></tr>
		  <tr><td valign="top"><span class="req">*&nbsp;</span>Problem:</td><td><textarea name="problem"></textarea></td></tr>
		  <tr><td colspan="2" align="right"><input type="submit" name="Submit" value="Submit"></td></tr>
		  </table>
		  </div>
		    </form>
	      <% end if %>
		  
		</div>
		<!-- END CONTENT BODY -->
 
<!--#include virtual="/includes/asp/cms_footer.asp"-->

Open in new window

0
 
CHCCITAuthor Commented:
Database Snapshot
Database.bmp
0
 
Mark WoodNetwork AdministratorCommented:
compare my code to what you posted and you will see the edits.
0
 
CHCCITAuthor Commented:
Mrwood6275

Great your code is working it returns me an error code

Computer Work Order

Microsoft OLE DB Provider for SQL Server error '80040e14'

Invalid column name 'location'.

/forms/computer_work_order.asp, line 68


I would assume I need to add a column called location in the database and that should finalize this ordeal.
0
 
CHCCITAuthor Commented:
SQL Field  Added. Everything is in working order on the submission for my work order page. I am just having an issue with the actual work order page not showing the location field. Im not sure if I should close this topic and post my third part question in a new question or post it here.
<!--#include virtual="/includes/asp/cms_header.asp"-->
 
<!-- MENUS -->
<!--#include virtual="/includes/asp/cms_right_menu.asp"-->
<!-- END MENUS -->
 
<script language="javascript" src="/includes/js/formutils.js" type="text/javascript"></script>
<script language="JavaScript">
 
function isValid() {
  with (document.myForm) {
     if (name.value =="") { // check For First Name
    alert("ATTENTION\n\n\n..\nName is required.\n..\n\n\n");
    name.focus();
	return false;
   }      
   if (ext.value =="") { // check For extention
    alert("ATTENTION!\n\n\n..\nExtension is required.\n..\n\n\n");
    ext.focus();
	return false;
   } 
   if (login.value =="") { // check Login is required.\n..\n\n\n");
    alert("ATTENTION\n\n\n..\nNetwork Credentials Required.\n..\n\n\n");
    login.focus();
	return false;
   }  
   if (password.value =="") { // check For Passord
    alert("ATTENTION\n\n\n..\nNetwork Password is required.\n..\n\n\n");
    password.focus();
	return false;
   }
   
   if (location.value =="") { // check For Location
    alert("ATTENTION\n\n\n..\nLocation is required.\n..\n\n\n");
    password.focus();
	return false;
   }
   if (problem.value =="") { // check For problem
    alert("ATTENTION\n\n\n..\nproblem is required.\n..\n\n\n");
    problem.focus();
	return false;
   }  
 
 }
 return true;
}
    </script> 
<!-- BEGIN CONTENT BODY -->
		<div id="content_body">
		  <p class="page_title">Computer Work Order</p>
		  <% if Request.Form("Submit") = "Submit" then 
			set objRS = server.CreateObject("adodb.recordset")
			
			employee_name = replace(request.form("name"), "'", "''")
			problem = replace(request.form("problem"), "'", "''")
			problem = replace(problem, vbcrlf, "<br>")
			outputProblem = problem
			if request.Form("login") <> "" then
				problem = problem & "<br>Login: " & request.Form("login")
			end if
			if request.Form("password") <> "" then
				problem = problem & "<br>Password: " & request.Form("password")
			end if
			strSql = "set nocount on "
			strSql = strSql & "insert into wo (request_date,employee_name,employee_phone,problem,location,wo_type) values ("
			strSql = strSql & "'" & now() & "', "
			strSql = strSql & "'" & employee_name & "', "
			strSql = strSql & "'" & request.Form("ext") & "', "
			strSql = strSql & "'" & request.Form("location") & "', "
			strSql = strSql & "'" & problem & "', "
			strSql = strSql & "1) "
			strSql = strSql & "select last_insert_id=@@IDENTITY "
			strSql = strSql & "set nocount off"
			objRS.open strSql, objConn
			%>
			<p class='body'>The work order has been submitted, for your reference here is the information you submitted:</p>
			<table cellpadding="3" cellspacing="0" border="0" class="body">
			<tr><td>Employee:&nbsp;</td><td><%= request.Form("name") %></td></tr>
			<tr><td>Extension:&nbsp;</td><td><%= request.Form("ext") %></td></tr>
			<tr><td valign="top">Location</td><td><%= request.Form("location") %></td></tr>
			<tr><td valign="top">Description:&nbsp;</td><td><%= outputProblem %></td></tr>
			<tr><td>Work&nbsp;Order&nbsp;#:&nbsp;</td><td><%= objRS("last_insert_id") %></td></tr>
			</table>
			<p class="body"><a href="computer_work_order.asp">Click here</a> if you want to submit another Computer Work Order.</p>
			<p class="body"><a href="/">Back to CHCC Home</a></p>
		  <% else %>
		  
	      <p class="body">If you are submitting a Computer Work Order about a new hire, please use the <a href="/forms/new_hire.asp">New Hire / Replacement Request Form</a>.</p>
	      <form name="myForm" action="computer_work_order.asp" method="post" onSubmit="return isValid()">
		  <div class="body">
		  <table cellpadding="3" cellspacing="0" border="0">
		  <tr><td><span class="req">*&nbsp;</span>Name:</td><td><input type="text" name="name"></td></tr>
		  <tr><td><span class="req">*&nbsp;</span>Extension:</td><td><input type="text" name="ext"></td></tr>
		  <tr><td><span class="req">*&nbsp;</span>User Name:</td><td><input type="text" name="login"></td></tr>
		  <tr><td valign="top"><span class="req">*&nbsp;</span>Password:</td><td><input type="password" name="password"><br><font size="1">Your password will appear as *'s for safety</font></td></tr>
		  <tr><td valign="top"><span class="req">*&nbsp;</span> Location</td><td><input type="text" name="location"></td></tr>
		  <tr><td valign="top"><span class="req">*&nbsp;</span>Problem:</td><td><textarea name="problem"></textarea></td></tr>
		  <tr><td colspan="2" align="right"><input type="submit" name="Submit" value="Submit"></td></tr>
		  </table>
		  </div>
		    </form>
	      <% end if %>
		  
		</div>
		<!-- END CONTENT BODY -->
 
<!--#include virtual="/includes/asp/cms_footer.asp"-->

Open in new window

0
 
CHCCITAuthor Commented:
I am going to close and award points. Thanks For your help everyone. I will post a part 3 and this should close out everything.
0
 
CHCCITAuthor Commented:
Thank you all for the help. I will post a follow up question to this topic and this should close out all my issues thanks again.
0
 
Mark WoodNetwork AdministratorCommented:
that is all you need to do is add column named "location" to the database.
0
 
CHCCITAuthor Commented:
Mwood6275

Thank you for your help and support. With the changes I have made to the sql database and additions to the code here is what I came up with your help thanks.
<!--#include virtual="/includes/asp/cms_header.asp"-->
 
<!-- MENUS -->
<!--#include virtual="/includes/asp/cms_right_menu.asp"-->
<!-- END MENUS -->
 
<script language="javascript" src="/includes/js/formutils.js" type="text/javascript"></script>
<script language="JavaScript">
 
function isValid() {
  with (document.myForm) {
     if (name.value =="") { // check For First Name
    alert("ATTENTION\n\n\n..\nName is required.\n..\n\n\n");
    name.focus();
	return false;
   }      
   if (ext.value =="") { // check For extention
    alert("ATTENTION!\n\n\n..\nExtension is required.\n..\n\n\n");
    ext.focus();
	return false;
   } 
   if (login.value =="") { // check Login is required.\n..\n\n\n");
    alert("ATTENTION\n\n\n..\nNetwork Credentials Required.\n..\n\n\n");
    login.focus();
	return false;
   }  
   if (password.value =="") { // check For Passord
    alert("ATTENTION\n\n\n..\nNetwork Password is required.\n..\n\n\n");
    password.focus();
	return false;
   }
   
   if (location.value =="") { // check For Location
    alert("ATTENTION\n\n\n..\nLocation is required.\n..\n\n\n");
    password.focus();
	return false;
   }
   if (problem.value =="") { // check For problem
    alert("ATTENTION\n\n\n..\nproblem is required.\n..\n\n\n");
    problem.focus();
	return false;
   }  
 
 }
 return true;
}
    </script> 
<!-- BEGIN CONTENT BODY -->
		<div id="content_body">
		  <p class="page_title">Computer Work Order</p>
		  <% if Request.Form("Submit") = "Submit" then 
			set objRS = server.CreateObject("adodb.recordset")
			
			employee_name = replace(request.form("name"), "'", "''")
			problem = replace(request.form("problem"), "'", "''")
			problem = replace(problem, vbcrlf, "<br>")
			outputProblem = problem
			if request.Form("login") <> "" then
				problem = problem & "<br>Login: " & request.Form("login")
			end if
			if request.Form("password") <> "" then
				problem = problem & "<br>Password: " & request.Form("password")
			end if
			if request.Form("location") <> "" then
				problem = problem & "<br>Location: " & request.Form("location")
			end if
			strSql = "set nocount on "
			strSql = strSql & "insert into wo (request_date,employee_name,employee_phone,location,problem,wo_type) values ("
			strSql = strSql & "'" & now() & "', "
			strSql = strSql & "'" & employee_name & "', "
			strSql = strSql & "'" & request.Form("ext") & "', "
			strSql = strSql & "'" & location & "', "
			strSql = strSql & "'" & problem & "', "
			strSql = strSql & "1) "
			strSql = strSql & "select last_insert_id=@@IDENTITY "
			strSql = strSql & "set nocount off"
			objRS.open strSql, objConn
			%>
			<p class='body'>The work order has been submitted, for your reference here is the information you submitted:</p>
			<table cellpadding="3" cellspacing="0" border="0" class="body">
			<tr><td>Employee:&nbsp;</td><td><%= request.Form("name") %></td></tr>
			<tr><td>Extension:&nbsp;</td><td><%= request.Form("ext") %></td></tr>
			<tr><td valign="top">Location</td><td><%= request.Form("location") %></td></tr>
			<tr><td valign="top">Description:&nbsp;</td><td><%= outputProblem %></td></tr>
			<tr><td>Work&nbsp;Order&nbsp;#:&nbsp;</td><td><%= objRS("last_insert_id") %></td></tr>
			</table>
			<p class="body"><a href="computer_work_order.asp">Click here</a> if you want to submit another Computer Work Order.</p>
			<p class="body"><a href="/">Back to CHCC Home</a></p>
		  <% else %>
		  
	      <p class="body">If you are submitting a Computer Work Order about a new hire, please use the <a href="/forms/new_hire.asp">New Hire / Replacement Request Form</a>.</p>
	      <form name="myForm" action="computer_work_order.asp" method="post" onSubmit="return isValid()">
		  <div class="body">
		  <table cellpadding="3" cellspacing="0" border="0">
		  <tr><td><span class="req">*&nbsp;</span>Name:</td><td><input type="text" name="name"></td></tr>
		  <tr><td><span class="req">*&nbsp;</span>Extension:</td><td><input type="text" name="ext"></td></tr>
		  <tr><td><span class="req">*&nbsp;</span>User Name:</td><td><input type="text" name="login"></td></tr>
		  <tr><td valign="top"><span class="req">*&nbsp;</span>Password:</td><td><input type="password" name="password"><br><font size="1">Your password will appear as *'s for safety</font></td></tr>
		  <tr><td valign="top"><span class="req">*&nbsp;</span> Location</td><td><input type="text" name="location"></td></tr>
		  <tr><td valign="top"><span class="req">*&nbsp;</span>Problem:</td><td><textarea name="problem"></textarea></td></tr>
		  <tr><td colspan="2" align="right"><input type="submit" name="Submit" value="Submit"></td></tr>
		  </table>
		  </div>
		    </form>
	      <% end if %>
		  
		</div>
		<!-- END CONTENT BODY -->
 
<!--#include virtual="/includes/asp/cms_footer.asp"-->

Open in new window

0
 
Mark WoodNetwork AdministratorCommented:
Glad I could help. If you need anything further just let me know and I will see what I can do.
0
 
CHCCITAuthor Commented:
Thanks Again
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.