<%@ Language=JScript%>
<%
var oConn, oRs, oRs1, a, b="", aa, ab, ac, ad, ae, af=0,as;
ab=parseInt(Request.QueryString("ShipperID"));ac=Request.QueryString("CompanyName");ad=Request.QueryString("Phone");
ae=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 max(case when CompanyName='"+ac+"' And Phone='"+ad+"' then '1' else '0' end) FROM Shippers;");
if(oRs.Fields.Item(0).Value==1){af=1;}
else{oConn.Execute ("insert into Shippers (CompanyName, Phone) values ('"+ac+"','"+ad+"');");}}
if(Request.QueryString("UpID")==2){oConn.Execute("Delete from Shippers where ShipperID="+ab+";");}
if(Request.QueryString("UpID")==3){a="update Shippers SET ";
if(ac>""){a=a+"CompanyName='"+ac+"'";}
if(ac>""&&ad>""){a=a+", ";}
if(ad>""){a=a+"Phone='"+ad+"'";}
a=a+" where ShipperID="+ab+";";
oConn.Execute(a);}
%>
SQL Northwind - Shippers Updater