<%@ LANGUAGE = JScript %> <% Response.Expires= -1 %> <% var oConn,oRs,oRs1,a,b="",c,d,g,aa,ab,ac,ad,ae,af,ag,ah,ai,aj,ak,al,am,an,ao,ap,aq,ar=0,as,at,au,av,ba; 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("BDt");au=Request.QueryString("HDt");av=Request.QueryString("Act"); oConn = Server.CreateObject("ADODB.Connection"); oConn.Open(av); if(Request.QueryString("UpID")==1){a="Select Max(case when TitleOfCourtesy='"+ag+"' And FirstName='"+ae+"' And LastName='"+af+"'"; a=a+" And PostalCode='"+ak+"' And HomePhone='"+am+"' then '1' else '0' end) 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+"',"; if(an>""&&an!=null){a=a+"'"+an+"',";}else{a=a+"null,";} if(ao>""&&ao!=null){a=a+"'"+at+"',";} else{a=a+"null,";} if(ap>""&&ap!=null){a=a+"'"+au+"',";} else{a=a+"null,";} a=a+"'"+aq+"');"; oConn.Execute(a);}} if(Request.QueryString("UpID")==2){oConn.Execute("Delete from Employees where EmployeeID="+ab+";");} 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='"+at+"'"}else{a=a+"Birthdate=null";} if(ap!=null&&ap>""){a=a+",HireDate='"+au+"'";}else{a=a+",HireDate=null";} a=a+",Notes='"+aq+"' where EmployeeID="+ab+";"; oConn.Execute(a);} %> <%if(g>""||g>=-1){Response.Write(""+g+"");}%>

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, case when day(Birthdate)<=9 then '0'+convert(char(1),day(Birthdate)) else convert(char(2),"; a=a+"day(Birthdate)) end +'/'+case when month(Birthdate)<=9 then '0'+convert(char(1),month(Birthdate)) else convert("; a=a+"char(2),month(Birthdate)) end +'/'+convert(char(4),Year(Birthdate)) As Birthdate, case when day(HireDate)<=9 then '0'"; a=a+"+convert(char(1),day(HireDate)) else convert(char(2),day(HireDate)) end +'/'+case when month(HireDate)<=9 then '0'+"; a=a+"convert(char(1),month(HireDate)) else convert(char(2),month(HireDate)) end +'/'+convert(char(4),Year(HireDate)) As "; a=a+"HireDate, Notes from 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 TitleOfCourtesy From Employees Group By TitleOfCourtesy;"); for(i=0;oRs1("TitleOfCourtesy")!=null&&oRs1.EOF!=1;i++){b=b+"0&&oRs("TitleOfCourtesy").value==oRs1("TitleOfCourtesy").value&&Request.QueryString("UpID")!=2){b=b+" SELECTED ";} else if(Request.QueryString("UpID")!=2&&ag>""&&aa!=aa){if(ag==oRs1("TitleOfCourtesy").value){b=b+" SELECTED ";}} b=b+"VALUE='"+oRs1("TitleOfCourtesy")+"'>"+oRs1("TitleOfCourtesy")+"\n";oRs1.moveNext;} 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!