<%@ LANGUAGE = JScript %> <% Response.Expires= -1 %> <% var oConn, oRs, a, b="", aa,as; aa=parseInt(Request.QueryString("OrderID"));as=Request.QueryString("Act"); oConn = Server.CreateObject("ADODB.Connection"); oConn.Open(as); %>

Order ID	<% if(Request.QueryString("UpID")!=2&&aa>0){Response.Write("SELECT FROM LIST\n");} else{Response.Write("SELECT FROM LIST\n");} a="SELECT OrderID, case when day(OrderDate)<=9 then '0'+convert(char(1),day(OrderDate)) else convert(char(2),day(OrderDate)) "; a=a+"end +'/'+case when month(OrderDate)<=9 then '0'+convert(char(1),month(OrderDate)) else convert(char(2),month(OrderDate)) "; a=a+"end +'/'+convert(char(4),Year(OrderDate)) As OrderDate, Customers.CustomerID, ShipName, ContactName,Phone FROM Orders "; a=a+"INNER JOIN Customers ON Customers.CustomerID=Orders.CustomerID Order By CompanyName,OrderID;"; oRs = oConn.Execute(a); while(oRs("OrderID")!=null&&oRs.EOF!=1){ b=b+"0&&aa==oRs("OrderID")){b=b+" selected";} b=b+">"+oRs("OrderID")+" - "+oRs("OrderDate")+" - "+oRs("CustomerID")+" - "+oRs("ShipName")+" - "+oRs("ContactName")+" - "; b=b+oRs("Phone")+""; oRs.moveNext();b=b+"\n";} Response.Write(b); %>
For Deleting and Updating Only!!!						UPDATE!

---