<% rsX.movenext: loop else %> Not found. <% end if end if %>
Warranty:
<%
if request.form("submit") = "Search" then
sql = "select * from warranty where dist_id = " & session("dist_id") & " and (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 dist_id = " & session("dist_id") & " and (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: