<% sn = request.form("sn") %>

Search Results for Serial Number <%=sn%>

Start-Up Form: <% if request.form("submit") = "Search" then sql = "select * from startup where (Serial_Number = '" & sn & "' or Customer_Name like '%" & sn & "%')" set rsX = conn.Execute(sql) if not rsX.eof then Do while not rsX.eof%> "><%=rsX("customer_name")%>

<% rsX.movenext: loop else %> Not found. <% end if end if %>

Warranty: <% if request.form("submit") = "Search" then sql = "select * from warranty where (serial_num = '" & sn & "' or customer_name like '%" & sn & "%')" set rsX = conn.Execute(sql) if not rsX.eof then Do while not rsX.eof%> "><%=rsX("customer_name")%>

<% rsX.movenext: loop else %> Not found. <% end if end if %>

RMA: <% if request.form("submit") = "Search" then sql = "select * from rma where (serial_num = '" & sn & "' or customer like '%" & sn & "%')" set rsX = conn.Execute(sql) if not rsX.eof then Do while not rsX.eof%> "># <%=rsX("rma_num")%>

<% rsX.movenext: loop else %> Not found. <% end if end if %>


New Search:

Enter Serial Number or Customer Name:
(You can use part of the Customer Name.)