<%@ LANGUAGE = JScript %> <% Response.Expires= -1 %> <% var oConn, oRs, oRs1, a, b="", ba, aa, ab, ac, ad, ae, af, ag, ah, ai, aj, ak, al, am, an, ao, ap, aq, ar=0, as,at; aa=parseInt(Request.QueryString("EmployeeID"));ab=parseInt(Request.QueryString("EID"));as=Request.QueryString("UpID"); ac=parseInt(Request.QueryString("ReportsTo"));ad=Request.QueryString("Title");ae=Request.QueryString("FirstName"); af=Request.QueryString("LastName");ag=Request.QueryString("TitleOfCourtesy");ah=Request.QueryString("Address"); ai=Request.QueryString("City");aj=Request.QueryString("Region");ak=Request.QueryString("PostalCode"); al=Request.QueryString("Country");am=Request.QueryString("HomePhone");an=Request.QueryString("Extension"); ao=Request.QueryString("Birthdate");ap=Request.QueryString("HireDate");aq=Request.QueryString("Notes"); at=Request.QueryString("Act"); oConn = Server.CreateObject("ADODB.Connection"); oConn.Open(at); if(Request.QueryString("UpID")==1){a=" Select Sum(IIf(TitleOfCourtesy='"+ag+"' And FirstName='"+ae+"' And LastName='"+af+"' "; a=a+"And PostalCode='"+ak+"' And HomePhone='"+am+"',1,0)) FROM Employees;"; oRs = oConn.Execute(a); if(oRs.Fields.Item(0).Value>=1){ar=1;} else{a="insert into Employees (ReportsTo, Title, FirstName, LastName, TitleOfCourtesy, Address, City, Region,"; a=a+" PostalCode, Country, HomePhone, Extension, Birthdate, HireDate, Notes)"; a=a+" values ("+ac+",'"+ad+"','"+ae+"','"+af+"','"+ag+"','"+ah+"','"+ai+"','"+aj+"','"+ak+"','"+al+"','"+am+"','"; a=a+an+"',"; if(ao>""&&ao!=null){a=a+"format(format('"+ao+"','dd/mm/yyyy'),'mm/dd/yyyy'),";}else{a=a+"null,";} if(ap>""&&ap!=null){a=a+"format(format('"+ap+"','dd/mm/yyyy'),'mm/dd/yyyy'),";}else{a=a+"null,";} a=a+"'"+aq+"');"; oConn.Execute(a);}} if(Request.QueryString("UpID")==2){oConn.Execute("Delete EmployeeID from Employees where EmployeeID="+aa+";");} if(Request.QueryString("UpID")==3){a=" update Employees SET ReportsTo="+ac+",Title='"+ad+"',FirstName='"+ae+"'"; a=a+",LastName='"+af+"',TitleOfCourtesy='"+ag+"',Address='"+ah+"',City='"+ai+"',Region='"+aj+"'"; a=a+",PostalCode='"+ak+"',Country='"+al+"',HomePhone='"+am+"',Extension='"+an+"',"; if(ao!=null&&ao>""){a=a+"Birthdate=format(format('"+ao+"','dd/mm/yyyy'),'mm/dd/yyyy')";}else{a=a+"Birthdate=null";} if(ap!=null&&ap>""){a=a+",HireDate=format(format('"+ap+"','dd/mm/yyyy'),'mm/dd/yyyy')";}else{a=a+",HireDate=null";} a=a+",Notes='"+aq+"' where EmployeeID="+ab+";"; oConn.Execute(a);} %>

Employee ID

<% if(Request.QueryString("UpID")!=2&&aa>0){Response.Write("SELECT FROM LIST\n");} else{Response.Write("SELECT FROM LIST\n");} oRs = oConn.Execute("Select * from Employees ORDER BY FirstName, LastName;"); while(oRs("EmployeeID")!=null&&oRs.EOF!=1){b=b+"0&&aa==oRs("EmployeeID")){b=b+"selected ";} b=b+"VALUE="+oRs("EmployeeID")+">"+oRs("TitleOfCourtesy")+" - "+oRs("FirstName")+" "+oRs("LastName")+" - "; b=b+oRs("Title")+" - "+oRs("HomePhone")+" - "+oRs("City")+""; oRs.moveNext();b=b+"\n";} Response.Write(b); %>

For Deleting and Updating Only!!!              <% if(ar==1){Response.Write("Could not add Record, Record already exists!")}%>

---

");} else if(ah>""&&Request.QueryString("UpID")!=2){Response.Write(">"+ah+"");} else{Response.Write(">");} %> ");} else if(Request.QueryString("UpID")!=2&&aq>""){Response.Write(">"+aq+"");} else{Response.Write(">.");} %>

Employee ID	0&&Request.QueryString("UpID")!=2){Response.Write(ab);} else if(Request.QueryString("UpID")==1){ a="Select EmployeeID, ReportsTo, Title, FirstName, LastName, TitleOfCourtesy, Address, City, Region, PostalCode, Country, "; a=a+"HomePhone, Extension, Format(Birthdate,'dd/mm/yyyy') As Birthdate, Format(HireDate,'dd/mm/yyyy') As HireDate, Notes from "; a=a+"Employees Where TitleOfCourtesy='"+ag+"' And FirstName='"+ae+"' And LastName='"+af+"' "; a=a+"And PostalCode='"+ak+"' And HomePhone='"+am+"';"; oRs = oConn.Execute (a); Response.Write(oRs("EmployeeID"));} %> ">	Title	0){Response.Write(oRs("Title"));} else if(ad>""&&Request.QueryString("UpID")!=2){Response.Write(ad);} %> ">
Reports To	<% b=""; if(Request.QueryString("UpID")!=2&&ac>0||aa>0){Response.Write("SELECT FROM LIST\n");} else{Response.Write("SELECT FROM LIST\n");} oRs1 = oConn.Execute ( " Select * from Employees ORDER BY FirstName, LastName;"); while(oRs1("EmployeeID")!=null&&oRs1.EOF!=1){ b=b+"0&&parseInt(oRs1("EmployeeID"))==oRs("ReportsTo")&&Request.QueryString("UpID")!=2){b=b+" SELECTED ";} else if(Request.QueryString("UpID")!=2&&ac>0&&aa!=aa){if(ac==oRs1("EmployeeID")){b=b+" SELECTED ";}} b=b+"VALUE="+oRs1("EmployeeID")+">"+oRs1("TitleOfCourtesy")+" - "+oRs1("FirstName")+" "+oRs1("LastName")+" - "; b=b+oRs1("Title")+" - "+oRs1("HomePhone")+" - "+oRs1("City")+""; oRs1.moveNext();b=b+"\n";} Response.Write(b); %>			Hire Date	""&&Request.QueryString("UpID")!=2){Response.Write(ap);} %> ">
Dear	<% b=""; if(Request.QueryString("UpID")!=2&&ag>""||aa>0){Response.Write("Select\n");} else{Response.Write("Select\n");} oRs1=oConn.Execute("Select 'Chief' As 1, 'Dr.' As 2, 'Miss' As 3, 'Mr.' As 4, 'Mrs.' As 5, 'Ms.' As 6, 'Prof.' As 7;"); for(i=0;i<7;i++){b=b+"0&&oRs("TitleOfCourtesy").value==oRs1(i).value&&Request.QueryString("UpID")!=2){b=b+" SELECTED ";} else if(Request.QueryString("UpID")!=2&&ag>""&&aa!=aa){if(ag==oRs1(i).value){b=b+" SELECTED ";}} b=b+"VALUE='"+oRs1(i)+"'>"+oRs1(i)+"\n";} Response.Write(b); %>	First Name	""&&Request.QueryString("UpID")!=2){Response.Write(ae);} %> ">	Last Name	""&&Request.QueryString("UpID")!=2){Response.Write(af);} %> ">
Address	0){Response.Write(">"+oRs("Address")+"			City	""&&Request.QueryString("UpID")!=2){Response.Write(ai);} %> ">
Region	0&&Request.QueryString("UpID")!=2){Response.Write(oRs("Region"));} else if(aj!="null"&&ah>""&&Request.QueryString("UpID")!=2){Response.Write(aj);} %> ">	PostalCode	0&&Request.QueryString("UpID")!=2){Response.Write(oRs("PostalCode"));} else if(ai!="null"&&ak>""&&Request.QueryString("UpID")!=2){Response.Write(ak);} %> ">	Country	""&&Request.QueryString("UpID")!=2){Response.Write(al);} %> ">
Home Phone	0&&Request.QueryString("UpID")!=2){Response.Write(oRs("HomePhone"));} else if(aj!="null"&&am>""&&Request.QueryString("UpID")!=2){Response.Write(am);} %> ">	Extension	""&&Request.QueryString("UpID")!=2){Response.Write(an);} %> ">	Birthdate	""&&Request.QueryString("UpID")!=2){Response.Write(ao);} %> ">
Notes	0&&Request.QueryString("UpID")!=2){Response.Write(">"+oRs("Notes")+"
ADD!     DELETE!     UPDATE!     CLEAR/REFRESH!