Check value of model number then do something based on that
I have to list of model numbers with about 10-15 different models each and if they are in list A then i need Label #1 printed and if in list B then I need Lable #2 printed.
Model Numbers for ETL
Plus I need it to still check to see if record exist in the label table, and if the value is > 0.
This is what I have right now but it does not look at the model numbers:
strSQL2 = "SELECT * FROM labels WHERE sf_ord = " & rs("ord_no")
set rs2 = Conn.Execute(strSQL2)
if rs2.BOF AND rs2.EOF then%><b><font size="4">
<a target="_blank" href="labelprint.asp?ordno=<%= rs("ord_no") %>">Print First</a>