<%
dist_id = session("dist_id")
'on error resume next
%>
RMA List
| Customer Name |
RMA # |
Serial Number |
Entry Date |
Status |
<%
sql = "select rma_id,rma_num,date_entered,customer,serial_num,status from rma where dist_id = " & dist_id & " and closed = 0"
set rs = conn.Execute(sql)
do while not rs.eof%>
| "><%=rs("customer")%> |
<%=rs("rma_num")%> |
<%=rs("serial_num")%> |
<%=rs("date_entered")%> |
<%=rs("status")%> |
<%
rs.movenext: loop %>