<% OrderID=request("OrderID") Set OS1=server.createobject("ADODB.recordset") Set OS2=server.createobject("ADODB.recordset") %> Order Invoice
<%if NOT ISNULL(OrderID) AND LEN(OrderID) > 0 then SQL="SELECT * from OrderHistory WHERE OrderID='"&OrderID&"'" OS1.open SQL, conn, adOpenStatic, AdLockReadOnly SQL="SELECT * from CurrentOrders WHERE OrderID='"&OrderID&"'" OS2.open SQL, conn, adOpenStatic, AdLockReadOnly %> <% end if %>
Customer Order Status
Please enter your Order Number from your invoice
Order Number:

<% if OS1.eof AND OS2.eof then %> <% end if if NOT OS1.eof then %> <% end if%>
Customer Order Status
for
<%=OrderID%>
<% if NOT OS1.eof then %> SHIPPED <% else if NOT OS2.eof then %> IN PROCESS <% else %> ORDER INFORMATION UNAVAILABLE <% end if end if%>
Order Date
Ship Date
Ship Method
Tracking Number
This order does not exist. Please check your Order Number and try again. If you feel this message is in error, please contact us at 1-888-790-FLEX (1-888-790-3539)
<%=OS1("OrderDate")%>
<%=OS1("DateShipped")%>
<%=OS1("ShipMethod")%>
<%=OS1("TrackingNum")%>