?
Solved

I need to add another field to my form

Posted on 2009-04-24
24
Medium Priority
?
772 Views
Last Modified: 2012-05-06
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
0
Comment
Question by:CHCCIT
  • 14
  • 5
  • 2
  • +2
24 Comments
 
LVL 13

Expert Comment

by:Onthrax
ID: 24228866
Sure.. what kind of field do you want to add?
0
 
LVL 54

Expert Comment

by:b0lsc0tt
ID: 24229171
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
 

Author Comment

by:CHCCIT
ID: 24229194
I just want to add a field that says
Location
if you need anything more or further please let me know. Thanks
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:CHCCIT
ID: 24229203
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
 
LVL 54

Assisted Solution

by:b0lsc0tt
b0lsc0tt earned 400 total points
ID: 24229437
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
 

Author Comment

by:CHCCIT
ID: 24229953
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
 

Author Comment

by:CHCCIT
ID: 24245555
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
 
LVL 2

Expert Comment

by:Kalpana_Natarajan
ID: 24245570
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
 
LVL 2

Expert Comment

by:Kalpana_Natarajan
ID: 24245586
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
 

Author Comment

by:CHCCIT
ID: 24246581
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
 
LVL 2

Expert Comment

by:Mark Wood
ID: 24246677
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
 

Author Comment

by:CHCCIT
ID: 24246709
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
 

Author Comment

by:CHCCIT
ID: 24246731
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
 

Author Comment

by:CHCCIT
ID: 24246790
Database Snapshot
Database.bmp
0
 
LVL 2

Accepted Solution

by:
Mark Wood earned 1600 total points
ID: 24246850
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
 
LVL 2

Expert Comment

by:Mark Wood
ID: 24246860
compare my code to what you posted and you will see the edits.
0
 

Author Comment

by:CHCCIT
ID: 24246896
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
 

Author Comment

by:CHCCIT
ID: 24247056
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
 

Author Comment

by:CHCCIT
ID: 24247135
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
 

Author Closing Comment

by:CHCCIT
ID: 31574392
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
 
LVL 2

Expert Comment

by:Mark Wood
ID: 24247223
that is all you need to do is add column named "location" to the database.
0
 

Author Comment

by:CHCCIT
ID: 24251453
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
 
LVL 2

Expert Comment

by:Mark Wood
ID: 24251928
Glad I could help. If you need anything further just let me know and I will see what I can do.
0
 

Author Comment

by:CHCCIT
ID: 24252183
Thanks Again
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When it comes to write a Context Sensitive Help (an online help that is obtained from a specific point in state of software to provide help with that state) ,  first we need to make the file that contains all topics, which are given exclusive IDs. …
Without even knowing it, most of us are using web applications on a daily basis.  In fact, Gmail and Yahoo email, Twitter, Facebook, and eBay are used by most of us daily—and they are web applications. We generally confuse these web applications to…
In this tutorial viewers will learn how to embed Flash content in a webpage using HTML5. Ensure your DOCTYPE declaration is set to HTML5: "<!DOCTYPE html>": Use the <object> tag to embed Flash content.: To specify that the object is Flash content, d…
The viewer will learn the basics of jQuery including how to code hide show and toggles. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery…
Suggested Courses

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question