<%@ LANGUAGE = JScript %> <% Response.Expires= -1 %> <% var oConn, oRs, a, b="", 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, Format(OrderDate,'dd/mm/yyyy') As OrderDate, Customers.CustomerID, ShipName, ContactName,Phone "; a=a+" FROM Orders 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!

---