<%@ LANGUAGE = JScript %>
<% Response.Expires= -1 %>
<%
var oConn, oRs, a, b="", aa, ab, ac, ad=0,as;
aa=parseInt(Request.QueryString("ContactTypeID"));ab=Request.QueryString("ContactType");
ac=parseInt(Request.QueryString("Srt"));as=Request.QueryString("Act");
oConn = Server.CreateObject("ADODB.Connection");
oConn.Open(as);
if(Request.QueryString("UpID")==1){oRs = oConn.Execute("Select Sum(IIf(ContactType='"+ab+"',1,0)) FROM ContactTypes;");
if(oRs.Fields.Item(0).Value>=1){ad=1;}
else{oConn.Execute("insert into ContactTypes (ContactType) values ('"+ab+"');");}}
if(Request.QueryString("UpID")==2){oConn.Execute("Delete ContactTypeID from ContactTypes where ContactTypeID="+aa+";");}
if(Request.QueryString("UpID")==3){a="update ContactTypes SET ContactType='"+ab+"' where ContactTypeID="+aa+";";
oConn.Execute(a);}
%>
Contact - Contact Type Updater