| |
<%
msql = "SELECT * FROM Orders Where ((((Orders.OrderDate)<='" & stopdate & "' And (Orders.OrderDate)>='" & startdate & "' )) AND Product2 = 'ACCELRTR') ORDER BY Orders.OrderID DESC"
Set RS=Conn.Execute(msql)
%>
| View? |
Disposition |
First Name |
Last Name |
City |
State |
Zip |
Order Date |
Order Time | <%Do While Not RS.EOF%>
| "> <%=RS("OrderID")%> |
<%=RS("Disposition")%> |
<%=RS("FirstName")%> |
<%=RS("LastName")%> |
<%=RS("City")%> |
<%=RS("State")%> |
<%=RS("Zip")%> |
<%=RS("OrderDate")%> |
<%=RS("OrderTime")%> | <%
total = total + 1
RS.MoveNext
Loop
RS.Close
Conn.Close
Set RS = Nothing
Set Conn = Nothing
%> Total Orders for period: <% = total %>
|
|
|
