<% if request.form("order_num") = "" then %>
<% else %>
<%
set conn=server.createobject("adodb.connection")
myDSN= "Data Source=//nawinfs02/home/users/web/b815/rh.readingbyear/database/bsb.mdb;Provider=Microsoft.Jet.OLEDB.4.0;"
conn.open myDSNset conn=server.createobject("adodb.connection")
conn.open myDSN
set rs=server.createobject("adodb.recordset")
form_order_num=request.form("order_num")
form_zipcode=request.form("zipcode")
mySQL="select order_num, zipcode from tblOrders"
' mySQL="select order_num, zipcode from tblOrdersOld"
mySQL=mySQL & " where order_num='" & form_order_num & "' AND zipcode='" & form_zipcode & "'"
rs.open mySQL, conn
%>
<% if not rs.eof then
response.redirect "https://readingbyear.readyhosting.com/secure/reorder.htm"
else %>
Your Order Number and Zip Code are not found in our Orders Database
Please call 815.777.3969 to verify your order.
Continue
<%
rs.close
set rs=nothing
conn.close
set conn=nothing
set mySQL=nothing
%>
<% end if %>
<% end if %>