<div>
where are these list a &amp;&nbsp;b stored? &nbsp;in a seperate table?
</div>

<div>
No, But i can create one... Right now i Have them in excel.
</div>

<div>
it would be best to place those lists in a table in your db. &nbsp;otherwise you would need to build an array or access the flat file every time. &nbsp;that would be very slow.
</div>

<div>
Ok I found that in the description some say Export and some say export w/******. &nbsp;How do i do a search for wildcards? 
SELECT &nbsp; &nbsp; *, item_desc_2 AS Expr1 
FROM &nbsp; &nbsp; &nbsp; &nbsp; imitmidx_sql 
WHERE &nbsp; &nbsp; (item_desc_2 = 'Export') &nbsp; &nbsp; &nbsp;&lt;----- Need to have a Wildcard after the word export. 
ORDER BY item_desc_2
</div>

<div>
Now that I have the filer, How should I write this I want it is to do this: 
1. check to see if record is in Labels 
2. If exist see if zn_4 is &gt;=0 
3. then want it to see if it is export or not. 
&nbsp; &nbsp;- IF in list do one thing and if not do another. 
In short i have 2 different labels I need to print based on the value and the zn_4 is a warning if the label has printed before. 
 
Now I have this in my ASP: 
&lt;% 
'DECLARATIONS 
dim dia, strID, strSQL, Conn, rs, strSQL2, strSQL3, strSQL4, strSQL5, rs2, rs3, rs4, rs5, ordno 
dia = Date() 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;strSQL = &quot;SELECT * FROM sfordfil_sql WHERE compl_dt='&quot;&amp; dia &amp;&quot;' ORDER BY ord_no DESC&quot; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;set rs = Conn.Execute(strSQL) 
&nbsp; &nbsp; strSQL2 = &quot;SELECT * FROM labels WHERE sf_ord = &quot;&nbsp;&amp; rs(&quot;ord_no&quot;) 
&nbsp; &nbsp; set rs2 = Conn.Execute(strSQL2) 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;strSQL3 = &quot;SELECT * FROM item_no WHERE item_desc_2 item_desc_2 LIKE 'export%'&quot; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;set rs3 = Conn.Execute(strSQL) 
%&gt; 
&lt;% While Not rs.EOF %&gt; 
&nbsp; &nbsp; &nbsp;&lt;tr&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td width=&quot;109&quot; align=&quot;center&quot;&gt;&lt;%= rs(&quot;ord_no&quot;) %&gt;&lt;/td&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td width=&quot;130&quot; align=&quot;center&quot;&gt;&lt;%= rs(&quot;item_no&quot;) %&gt;&lt;/td&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td width=&quot;208&quot; align=&quot;center&quot;&gt;&lt;%= rs(&quot;item_desc_1&quot;) %&gt;&lt;/td&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td width=&quot;128&quot; align=&quot;center&quot;&gt;&lt;%= rs(&quot;compl_dt&quot;) %&gt;&lt;/td&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td width=&quot;136&quot; align=&quot;center&quot;&gt; 
&lt;%if rs2.BOF AND rs2.EOF then%&gt; 
&lt;b&gt;&lt;font size=&quot;4&quot;&gt; 
&lt;a target=&quot;_blank&quot; href=&quot;labelprint.asp?ordno=&lt;%= rs(&quot;ord_no&quot;) %&gt;&quot;&gt;Print First&lt;/a&gt; 
 
&lt;%Elseif &nbsp;rs2(&quot;zn_4&quot;) = 0 then %&gt;&lt;/font&gt;&lt;/b&gt; &lt;b&gt; 
&lt;font size=&quot;4&quot;&gt; 
&lt;a target=&quot;_blank&quot; href=&quot;labelprint.asp?ordno=&lt;%= rs(&quot;ord_no&quot;) %&gt;&quot;&gt;Print First&lt;/a&gt; 
&lt;/font&gt;&lt;font size=&quot;2&quot;&gt; 
 
&lt;%Elseif &nbsp;rs2(&quot;zn_4&quot;) &gt;&nbsp;0 then %&gt;&lt;/font&gt;&lt;/b&gt; &lt;b&gt; 
&lt;a target=&quot;_blank&quot; href=&quot;labelprint.asp?ordno=&lt;%= rs(&quot;ord_no&quot;) %&gt;&quot;&gt;&lt;font size=&quot;1&quot;&gt;Completed&lt;/font&gt;&lt;/a&gt;&lt;font size=&quot;1&quot;&gt; 
 
&lt;%End If%&gt; 

</div>

<div>
So my code would look like this? 
 
query = &quot;SELECT *, &quot;&nbsp;&amp; _ 
&nbsp; &nbsp; &nbsp; &nbsp; &quot;(SELECT 'true' FROM labels WHERE sf_ord = &quot;&nbsp;&amp; rs(&quot;ord_no&quot;) &amp;&nbsp;&quot;) as inlabels, &quot;&nbsp;&amp; _ 
&nbsp; &nbsp; &nbsp; &nbsp; &quot;(SELECT 'true' FROM item_no WHERE item_desc_2 LIKE 'export%') as inexport &quot;&nbsp;&amp; _ 
&nbsp; &nbsp; &nbsp; &nbsp; &quot;FROM sfordfil_sql &quot;&nbsp;&amp; _ 
&nbsp; &nbsp; &nbsp; &nbsp; &quot;WHERE compl_dt='&quot;&amp; dia &amp;&quot;' &quot;&nbsp;&amp; _ 
&nbsp; &nbsp; &nbsp; &nbsp; &quot;ORDER BY ord_no DESC&quot; 
 
if query.BOF AND query.EOF and export = trure then %&gt; 
Test 1 Export 
&lt;%Else if query.BOF AND query.EOF then %&gt; 
Test 1 USA 
&lt;%Elseif &nbsp;rs1(&quot;zn_4&quot;) = 0 and export = trure then %&gt; 
Test 2 Export 
&lt;%Elseif &nbsp;rs1(&quot;zn_4&quot;) &gt;&nbsp;0 and export = trure then %&gt; 
Test 3 Export 
&lt;%Elseif &nbsp;rs1(&quot;zn_4&quot;) = 0 then %&gt; 
Test 2 USA 
&lt;%Elseif &nbsp;rs1(&quot;zn_4&quot;) &gt;&nbsp;0 then %&gt; 
Test 3 USA 
&lt;%end if%&gt;
</div>

<div>
Ok don't look at the last comment... .I might have found it... but i get page can't be displayed: &nbsp;(Any Ideas) 
 
&lt;%@LANGUAGE=&quot;VBSCRIPT&quot; CODEPAGE=&quot;1252&quot;%&gt; 
&lt;% 
Session(&quot;permission&quot;)=&quot;YES&quot; 
Session(&quot;username&quot;)=&quot;operator1&quot; 
%&gt; 
&lt;html&gt; 
&lt;head&gt; 
&lt;meta http-equiv=&quot;refresh&quot; content=&quot;120&quot;&gt; 
&lt;/head&gt; 
&lt;body&gt; 
&lt;% 
'CONNECTION 
Set conn = Server.CreateObject(&quot;ADODB.Connection&quot;) 
Conn.Open &quot;Provider=SQLOLEDB; Data Source=localhost; Initial Catalog=001; User ID=xxxxx; Password=xxxxx&quot; 
Set ObjRs = Server.CreateObject(&quot;ADODB.Recordset&quot;) 
 
'DECLARATIONS 
dim dia, strID, strSQL, Conn, rs, strSQL2, strSQL3, strSQL4, strSQL5, rs2, rs3, rs4, rs5, ordno 
dia = Date() 
strSQL = &quot;SELECT * FROM sfordfil_sql WHERE compl_dt is NULL ORDER BY ord_no DESC&quot; 
set rs = Conn.Execute(strSQL) 
 
strSQL3 = &quot;SELECT *, &quot;&nbsp;&amp; _ 
&nbsp; &nbsp; &nbsp; &nbsp; &quot;(SELECT 'true' FROM labels WHERE sf_ord = &quot;&nbsp;&amp; rs(&quot;ord_no&quot;) &amp;&nbsp;&quot;) as inlabels, &quot;&nbsp;&amp; _ 
&nbsp; &nbsp; &nbsp; &nbsp; &quot;(SELECT 'true' FROM item_no WHERE item_desc_2 LIKE 'export%') as inexport &quot;&nbsp;&amp; _ 
&nbsp; &nbsp; &nbsp; &nbsp; &quot;FROM sfordfil_sql &quot;&nbsp;&amp; _ 
&nbsp; &nbsp; &nbsp; &nbsp; &quot;ORDER BY ord_no DESC&quot; 
&nbsp; &nbsp; &nbsp; &nbsp; set rs3 = Conn.Execute(strSQL3) 
Response.Write(query) 
%&gt; 
&lt;div align=&quot;center&quot;&gt; 
&lt;table border=&quot;1&quot; width=&quot;745&quot; id=&quot;table1&quot; height=&quot;63&quot;&gt; 
&nbsp; &nbsp; &nbsp;&lt;tr&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td height=&quot;31&quot; width=&quot;109&quot; align=&quot;center&quot;&gt;Shop Order #&lt;/td&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td height=&quot;31&quot; width=&quot;130&quot; align=&quot;center&quot;&gt;Short Model #&lt;/td&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td height=&quot;31&quot; width=&quot;208&quot; align=&quot;center&quot;&gt;Item Description&lt;/td&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td height=&quot;31&quot; width=&quot;128&quot; align=&quot;center&quot;&gt;Start Date&lt;/td&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td height=&quot;31&quot; width=&quot;136&quot; align=&quot;center&quot;&gt;Print&lt;/td&gt; 
&nbsp; &nbsp; &nbsp;&lt;/tr&gt; 
&lt;% While Not rs3.EOF %&gt; 
&nbsp; &nbsp; &nbsp;&lt;tr&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td width=&quot;109&quot; align=&quot;center&quot;&gt;&lt;%= rs(&quot;ord_no&quot;) %&gt;&lt;/td&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td width=&quot;130&quot; align=&quot;center&quot;&gt;&lt;%= rs(&quot;item_no&quot;) %&gt;&lt;/td&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td width=&quot;208&quot; align=&quot;center&quot;&gt;&lt;%= rs(&quot;item_desc_1&quot;) %&gt;&lt;/td&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td width=&quot;128&quot; align=&quot;center&quot;&gt;&lt;%= rs(&quot;start_dt&quot;) %&gt;&lt;/td&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td width=&quot;136&quot; align=&quot;center&quot;&gt; 
&lt;%if rs3(&quot;inlabels&quot;) = true and rs3(&quot;inexport&quot;) = true and rs1(&quot;zn_4&quot;) &gt;&nbsp;0 then %&gt; 
Test 1 Export 
&lt;%Else if rs3(&quot;inlabels&quot;) = true and rs3(&quot;inexport&quot;) = true and rs1(&quot;zn_4&quot;) = 0 then %&gt; 
Test 2 Export 
&lt;%Else if rs3(&quot;inexport&quot;) = true then %&gt; 
Test 3 Export 
&lt;%Elseif rs3(&quot;inlabels&quot;) = true and rs1(&quot;zn_4&quot;) &gt;&nbsp;0 then %&gt; 
Test 1 USA 
&lt;%Elseif rs3(&quot;inlabels&quot;) = true and rs1(&quot;zn_4&quot;) = 0 then %&gt; 
Test 2 USA 
&lt;%Elseif then %&gt; 
Test 3 USA 
&lt;%End If%&gt; 
&lt;/font&gt;&lt;/b&gt; 
&lt;font size=&quot;1&quot;&gt; 
&lt;/font&gt;&lt;/font&gt;&lt;/td&gt; 
&lt;/tr&gt; 
&lt;% rs.MoveNext %&gt; 
&lt;% Wend %&gt; 
&lt;/table&gt; 
&lt;/div&gt; 
&lt;% 
'CLOSE 
conn.close 
set conn = nothing 
%&gt; 
&lt;/body&gt; 
&lt;/html&gt;
</div>

<div>
uncheck your friendly http errors so we can get details about the error. &nbsp;go to tools -&gt; internet options... -&gt; advanced tab
</div>

<div>
Ok I turned off friendly errors and have been working with the code a little and this this the New error: 
Microsoft OLE DB Provider for SQL Server error '80004005' 
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, &lt;, &lt;= , &gt;, &gt;= or when the subquery is used as an expression. 
/finial/1.asp, line 28 
 
Code: 
&lt;%@LANGUAGE=&quot;VBSCRIPT&quot; CODEPAGE=&quot;1252&quot;%&gt; 
&lt;%Session(&quot;permission&quot;)=&quot;YES&quot; 
Session(&quot;username&quot;)=&quot;operator1&quot;%&gt; 
&lt;html&gt; 
&lt;head&gt; 
&lt;meta http-equiv=&quot;refresh&quot; content=&quot;120&quot;&gt; 
&lt;/head&gt; 
&lt;body&gt; 
&lt;% 
'CONNECTION 
Set conn = Server.CreateObject(&quot;ADODB.Connection&quot;) 
Conn.Open &quot;Provider=SQLOLEDB; Data Source=localhost; Initial Catalog=001; User ID=xxxxxx; Password=xxxxxx&quot; 
Set ObjRs = Server.CreateObject(&quot;ADODB.Recordset&quot;) 
 
'DECLARATIONS 
dim dia, strID, strSQL, Conn, rs, strSQL2, strSQL3, strSQL4, strSQL5, rs2, rs3, rs4, rs5, ordno 
dia = Date() 
strSQL = &quot;SELECT * FROM sfordfil_sql WHERE compl_dt is NULL ORDER BY ord_no DESC&quot; 
set rs = Conn.Execute(strSQL) 
 
strSQL3 = &quot;SELECT *, &quot;&nbsp;&amp; _ 
&nbsp; &nbsp; &nbsp; &nbsp; &quot;(SELECT 'true' FROM labels WHERE sf_ord = &quot;&nbsp;&amp; rs(&quot;ord_no&quot;) &amp;&nbsp;&quot;) as inlabels, &quot;&nbsp;&amp; _ 
&nbsp; &nbsp; &nbsp; &nbsp; &quot;(SELECT 'true' FROM sfordfil_sql WHERE item_desc_2 LIKE 'export%') as inexport &quot;&nbsp;&amp; _ 
&nbsp; &nbsp; &nbsp; &nbsp; &quot;FROM sfordfil_sql &quot;&nbsp;&amp; _ 
&nbsp; &nbsp; &nbsp; &nbsp; &quot;ORDER BY ord_no DESC&quot; 
&nbsp; &nbsp; &nbsp; &nbsp; set rs3 = Conn.Execute(strSQL3) &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&lt;--------- This is where the error is coming from 
%&gt; 
&lt;div align=&quot;center&quot;&gt; 
&lt;table border=&quot;1&quot; width=&quot;745&quot; id=&quot;table1&quot; height=&quot;63&quot;&gt; 
&nbsp; &nbsp; &nbsp;&lt;tr&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td height=&quot;31&quot; width=&quot;109&quot; align=&quot;center&quot;&gt;Shop Order #&lt;/td&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td height=&quot;31&quot; width=&quot;130&quot; align=&quot;center&quot;&gt;Short Model #&lt;/td&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td height=&quot;31&quot; width=&quot;208&quot; align=&quot;center&quot;&gt;Item Description&lt;/td&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td height=&quot;31&quot; width=&quot;128&quot; align=&quot;center&quot;&gt;Start Date&lt;/td&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td height=&quot;31&quot; width=&quot;136&quot; align=&quot;center&quot;&gt;Print&lt;/td&gt; 
&nbsp; &nbsp; &nbsp;&lt;/tr&gt; 
&lt;% While Not rs3.EOF %&gt; 
&nbsp; &nbsp; &nbsp;&lt;tr&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td width=&quot;109&quot; align=&quot;center&quot;&gt;&lt;%= rs(&quot;ord_no&quot;) %&gt;&lt;/td&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td width=&quot;130&quot; align=&quot;center&quot;&gt;&lt;%= rs(&quot;item_no&quot;) %&gt;&lt;/td&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td width=&quot;208&quot; align=&quot;center&quot;&gt;&lt;%= rs(&quot;item_desc_1&quot;) %&gt;&lt;/td&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td width=&quot;128&quot; align=&quot;center&quot;&gt;&lt;%= rs(&quot;start_dt&quot;) %&gt;&lt;/td&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td width=&quot;136&quot; align=&quot;center&quot;&gt; 
&lt;%if rs3(&quot;inlabels&quot;) = true and rs3(&quot;inexport&quot;) = true and rs1(&quot;zn_4&quot;) &gt;&nbsp;0 then %&gt; 
Test 1 Export 
&lt;%Else if rs3(&quot;inlabels&quot;) = true and rs3(&quot;inexport&quot;) = true and rs1(&quot;zn_4&quot;) = 0 then %&gt; 
Test 2 Export 
&lt;%Else if rs3(&quot;inexport&quot;) = true then %&gt; 
Test 3 Export 
&lt;%Elseif rs3(&quot;inlabels&quot;) = true and rs1(&quot;zn_4&quot;) &gt;&nbsp;0 then %&gt; 
Test 1 USA 
&lt;%Elseif rs3(&quot;inlabels&quot;) = true and rs1(&quot;zn_4&quot;) = 0 then %&gt; 
Test 2 USA 
&lt;%Else%&gt; 
Test 3 USA 
&lt;%End If%&gt; 
&lt;/font&gt;&lt;/b&gt; 
&lt;font size=&quot;1&quot;&gt; 
&lt;/font&gt;&lt;/font&gt;&lt;/td&gt; 
&lt;/tr&gt; 
&lt;% rs.MoveNext %&gt; 
&lt;%end if%&gt; 
&lt;%end if%&gt; 
&lt;% Wend %&gt; 
&lt;/table&gt; 
&lt;/div&gt; 
&lt;% 
'CLOSE 
conn.close 
set conn = nothing 
%&gt; 
&lt;/body&gt; 
&lt;/html&gt;
</div>

<div>
Moving on up.... looks like we got by that one now... here is the next one.... 
error '80020009' 
/finial/1.asp, line 48 
 
&lt;%@LANGUAGE=&quot;VBSCRIPT&quot; CODEPAGE=&quot;1252&quot;%&gt; 
&lt;% 
Session(&quot;permission&quot;)=&quot;YES&quot; 
Session(&quot;username&quot;)=&quot;operator1&quot; 
%&gt; 
&lt;html&gt; 
&lt;head&gt; 
&lt;meta http-equiv=&quot;refresh&quot; content=&quot;120&quot;&gt; 
&lt;/head&gt; 
&lt;body&gt; 
&lt;% 
'CONNECTION 
Set conn = Server.CreateObject(&quot;ADODB.Connection&quot;) 
Conn.Open &quot;Provider=SQLOLEDB; Data Source=localhost; Initial Catalog=001; User ID=xxxxxx; Password=xxxxxx&quot; 
Set ObjRs = Server.CreateObject(&quot;ADODB.Recordset&quot;) 
'DECLARATIONS 
dim dia, strID, strSQL, Conn, rs, strSQL2, strSQL3, strSQL4, strSQL5, rs2, rs3, rs4, rs5, ordno 
dia = Date() 
strSQL = &quot;SELECT * FROM sfordfil_sql WHERE compl_dt is NULL ORDER BY ord_no DESC&quot; 
set rs = Conn.Execute(strSQL) 
strSQL3 = &quot;SELECT *, &quot;&nbsp;&amp; _ 
&nbsp; &nbsp; &nbsp; &nbsp; &quot;(SELECT top 1 'true' FROM labels WHERE sf_ord = &quot;&nbsp;&amp; rs(&quot;ord_no&quot;) &amp;&nbsp;&quot;) as inlabels, &quot;&nbsp;&amp; _ 
&nbsp; &nbsp; &nbsp; &nbsp; &quot;(SELECT top 1 'true' FROM sfordfil_sql WHERE item_desc_2 LIKE 'export%') as inexport &quot;&nbsp;&amp; _ 
&nbsp; &nbsp; &nbsp; &nbsp; &quot;FROM sfordfil_sql &quot;&nbsp;&amp; _ 
&nbsp; &nbsp; &nbsp; &nbsp; &quot;ORDER BY ord_no DESC&quot; 
&nbsp; &nbsp; &nbsp; &nbsp; set rs3 = Conn.Execute(strSQL3) 
strSQL1 = &quot;SELECT * FROM labels WHERE sf_ord = &quot;&nbsp;&amp; rs3(&quot;ord_no&quot;) 
set rs1 = Conn.Execute(strSQL1) 
%&gt; 
&lt;div align=&quot;center&quot;&gt; 
&lt;table border=&quot;1&quot; width=&quot;745&quot; id=&quot;table1&quot; height=&quot;63&quot;&gt; 
&nbsp; &nbsp; &nbsp;&lt;tr&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td height=&quot;31&quot; width=&quot;109&quot; align=&quot;center&quot;&gt;Shop Order #&lt;/td&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td height=&quot;31&quot; width=&quot;130&quot; align=&quot;center&quot;&gt;Short Model #&lt;/td&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td height=&quot;31&quot; width=&quot;208&quot; align=&quot;center&quot;&gt;Item Description&lt;/td&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td height=&quot;31&quot; width=&quot;128&quot; align=&quot;center&quot;&gt;Start Date&lt;/td&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td height=&quot;31&quot; width=&quot;136&quot; align=&quot;center&quot;&gt;Print&lt;/td&gt; 
&nbsp; &nbsp; &nbsp;&lt;/tr&gt; 
&lt;% While Not rs3.EOF %&gt; 
&nbsp; &nbsp; &nbsp;&lt;tr&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td width=&quot;109&quot; align=&quot;center&quot;&gt;&lt;%= rs(&quot;ord_no&quot;) %&gt;&lt;/td&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td width=&quot;130&quot; align=&quot;center&quot;&gt;&lt;%= rs(&quot;item_no&quot;) %&gt;&lt;/td&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td width=&quot;208&quot; align=&quot;center&quot;&gt;&lt;%= rs(&quot;item_desc_1&quot;) %&gt;&lt;/td&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td width=&quot;128&quot; align=&quot;center&quot;&gt;&lt;%= rs(&quot;start_dt&quot;) %&gt;&lt;/td&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td width=&quot;136&quot; align=&quot;center&quot;&gt; 
&lt;%if rs3(&quot;inlabels&quot;) = true and rs3(&quot;inexport&quot;) = true and rs1(&quot;zn_4&quot;) &gt;&nbsp;0 then %&gt; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&lt;--------- This line 
Test 1 Export 
&lt;%Else if rs3(&quot;inlabels&quot;) = true and rs3(&quot;inexport&quot;) = true and rs1(&quot;zn_4&quot;) = 0 then %&gt; 
Test 2 Export 
&lt;%Else if rs3(&quot;inexport&quot;) = true then %&gt; 
Test 3 Export 
&lt;%Elseif rs3(&quot;inlabels&quot;) = true and rs1(&quot;zn_4&quot;) &gt;&nbsp;0 then %&gt; 
Test 1 USA 
&lt;%Elseif rs3(&quot;inlabels&quot;) = true and rs1(&quot;zn_4&quot;) = 0 then %&gt; 
Test 2 USA 
&lt;%Else%&gt; 
Test 3 USA 
&lt;%End If%&gt; 
&lt;/font&gt;&lt;/b&gt; 
&lt;font size=&quot;1&quot;&gt; 
&lt;/font&gt;&lt;/font&gt;&lt;/td&gt; 
&lt;/tr&gt; 
&lt;% rs.MoveNext %&gt; 
&lt;%end if%&gt; 
&lt;%end if%&gt; 
&lt;% Wend %&gt; 
&lt;/table&gt; 
&lt;/div&gt; 
&lt;% 
'CLOSE 
conn.close 
set conn = nothing 
%&gt; 
&lt;/body&gt; 
&lt;/html&gt;
</div>

<div>
you might be getting eof on the rs1
</div>

<div>
Ok how do i get around that?
</div>

<div>
why do you even need that recordset? &nbsp;you are checking to see if its in the labels table already.
</div>

<div>
Here is what I am trying to do... I have a table called Labels and items will be added to this table normaly when an item is started in Zone 1. &nbsp;Each time it goes through a zone it checks to see if it is in the table and updates when a label is printed for each zone. &nbsp;So there may be a way around not needing to check for end of record for &nbsp;zone 4 normaly because when this system is in place it will be created in zone 1,2,or 3. &nbsp;What would you recommend that I do? &nbsp;And thank you for your help. 
 
(other information: the label table also will keep a copy of other data, i.e. model, sewr_lot, complete date.)
</div>

<div>
now im even more confused. &nbsp;i just saw that you have another recordset on this page to grab the order number list in descending order. &nbsp;you are using the latest order number to query rs1, but not rs3.
</div>

<div>
Ok, sorry for the delay... Been in meetings all day, I have changed the code and it is kind of working now.... It is showing records and gets an error at the bottom of the page, and skips does not find the exports. 
 
This is a sample of the output with the error: 
Shop Order # Short Model # Item Description Start Date Print 
3630 10202-LP &nbsp;Spa, w/Lounge 8' - Lapis &nbsp;4/28/2006 Test 3 USA &nbsp; 
3568 6100-SG &nbsp;Spa, w/Lounge 6' - Sage &nbsp;4/28/2006 Test 3 USA &nbsp; 
25 7100-PR &nbsp;Spa, w/Lounge 7' - Pearl &nbsp;4/28/2006 Test 3 USA &nbsp; 
24 7100-PR &nbsp;Spa, w/Lounge 7' - Pearl &nbsp;4/28/2006 Test 3 USA &nbsp; 
ADODB.Field error '80020009' 
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. 
/finial/1.asp, line 0 
&nbsp; 
Only runs the &lt;%Else%&gt; line. Do I need to change how my ElseIF lines are writen? 
Code: 
&lt;%@LANGUAGE=&quot;VBSCRIPT&quot; CODEPAGE=&quot;1252&quot;%&gt; 
&lt;%Session(&quot;permission&quot;)=&quot;YES&quot; 
Session(&quot;username&quot;)=&quot;operator1&quot;%&gt; 
&lt;html&gt;&lt;head&gt;&lt;meta http-equiv=&quot;refresh&quot; content=&quot;120&quot;&gt; 
&lt;/head&gt;&lt;body&gt; 
&lt;% 
'CONNECTION 
Set conn = Server.CreateObject(&quot;ADODB.Connection&quot;) 
Conn.Open &quot;Provider=SQLOLEDB; Data Source=localhost; Initial Catalog=001; User ID=xxxxx; Password=xxxxxx&quot; 
Set ObjRs = Server.CreateObject(&quot;ADODB.Recordset&quot;) 
 
'DECLARATIONS 
dim dia, strID, strSQL, Conn, rs, strSQL2, strSQL3, strSQL4, strSQL5, rs2, rs3, rs4, rs5, ordno 
dia = Date() 
strSQL = &quot;SELECT * FROM sfordfil_sql WHERE compl_dt is NULL ORDER BY ord_no DESC&quot; 
set rs = Conn.Execute(strSQL) 
 
strSQL3 = &quot;SELECT *, &quot;&nbsp;&amp; _ 
&nbsp; &nbsp; &nbsp; &nbsp; &quot;(SELECT top 1 'true' FROM labels WHERE sf_ord = &quot;&nbsp;&amp; rs(&quot;ord_no&quot;) &amp;&nbsp;&quot;) as inlabels, &quot;&nbsp;&amp; _ 
&nbsp; &nbsp; &nbsp; &nbsp; &quot;(SELECT top 1 'true' FROM sfordfil_sql WHERE item_desc_2 LIKE 'export%') as inexport &quot;&nbsp;&amp; _ 
&nbsp; &nbsp; &nbsp; &nbsp; &quot;FROM sfordfil_sql &quot;&nbsp;&amp; _ 
&nbsp; &nbsp; &nbsp; &nbsp; &quot;ORDER BY ord_no DESC&quot; 
&nbsp; &nbsp; &nbsp; &nbsp; set rs3 = Conn.Execute(strSQL3) 
strSQL1 = &quot;SELECT * FROM labels WHERE sf_ord = &quot;&nbsp;&amp; rs(&quot;ord_no&quot;) &amp;&nbsp;&quot;&quot; 
set rs1 = Conn.Execute(strSQL1) 
%&gt; 
&lt;div align=&quot;center&quot;&gt; 
&lt;table border=&quot;1&quot; width=&quot;745&quot; id=&quot;table1&quot; height=&quot;63&quot;&gt; 
&nbsp; &nbsp; &nbsp;&lt;tr&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td height=&quot;31&quot; width=&quot;109&quot; align=&quot;center&quot;&gt;Shop Order #&lt;/td&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td height=&quot;31&quot; width=&quot;130&quot; align=&quot;center&quot;&gt;Short Model #&lt;/td&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td height=&quot;31&quot; width=&quot;208&quot; align=&quot;center&quot;&gt;Item Description&lt;/td&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td height=&quot;31&quot; width=&quot;128&quot; align=&quot;center&quot;&gt;Start Date&lt;/td&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td height=&quot;31&quot; width=&quot;136&quot; align=&quot;center&quot;&gt;Print&lt;/td&gt; 
&nbsp; &nbsp; &nbsp;&lt;/tr&gt; 
&lt;% While Not rs3.EOF %&gt; 
&nbsp; &nbsp; &nbsp;&lt;tr&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td width=&quot;109&quot; align=&quot;center&quot;&gt;&lt;%= rs(&quot;ord_no&quot;) %&gt;&lt;/td&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td width=&quot;130&quot; align=&quot;center&quot;&gt;&lt;%= rs(&quot;item_no&quot;) %&gt;&lt;/td&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td width=&quot;208&quot; align=&quot;center&quot;&gt;&lt;%= rs(&quot;item_desc_1&quot;) %&gt;&lt;/td&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td width=&quot;128&quot; align=&quot;center&quot;&gt;&lt;%= rs(&quot;start_dt&quot;) %&gt;&lt;/td&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td width=&quot;136&quot; align=&quot;center&quot;&gt; 
&lt;%if rs3(&quot;inlabels&quot;) = true and rs3(&quot;inexport&quot;) = true and rs1(&quot;zn_4&quot;) &gt;&nbsp;0 then %&gt; 
Test 1 Export 
&lt;%Else if rs3(&quot;inlabels&quot;) = true and rs3(&quot;inexport&quot;) = true and rs1(&quot;zn_4&quot;) = 0 then %&gt; 
Test 2 Export 
&lt;%Else if rs3(&quot;inexport&quot;) = true then %&gt; 
Test 3 Export 
&lt;%Elseif rs3(&quot;inlabels&quot;) = true and rs1(&quot;zn_4&quot;) &gt;&nbsp;0 then %&gt; 
Test 1 USA 
&lt;%Elseif rs3(&quot;inlabels&quot;) = true and rs1(&quot;zn_4&quot;) = 0 then %&gt; 
Test 2 USA 
&lt;%Else%&gt; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&lt;---------It is skipping the others and jumping to this. 
Test 3 USA 
&lt;%End If%&gt; 
&lt;/font&gt;&lt;/b&gt; 
&lt;font size=&quot;1&quot;&gt; 
&lt;/font&gt;&lt;/font&gt;&lt;/td&gt; 
&lt;/tr&gt; 
&lt;% rs.MoveNext %&gt; 
&lt;%end if%&gt; 
&lt;%end if%&gt; 
&lt;% Wend %&gt; 
&lt;/table&gt; 
&lt;/div&gt; 
&lt;% 
'CLOSE 
conn.close 
set conn = nothing 
%&gt; 
&lt;/body&gt; 
&lt;/html&gt;
</div>

<div>
Ok fixed the EOF error, but what do i need to do to make it do the ELSEIF lines? 
dim dia, strID, strSQL, Conn, rs, strSQL2, strSQL3, strSQL4, strSQL5, rs2, rs3, rs4, rs5, ordno 
dia = Date() 
strSQL = &quot;SELECT * FROM sfordfil_sql WHERE compl_dt is NULL ORDER BY ord_no DESC&quot; 
set rs = Conn.Execute(strSQL) 
strSQL3 = &quot;SELECT *, &quot;&nbsp;&amp; _ 
&nbsp; &nbsp; &nbsp; &nbsp; &quot;(SELECT top 1 'true' FROM labels WHERE sf_ord = &quot;&nbsp;&amp; rs(&quot;ord_no&quot;) &amp;&nbsp;&quot;) as inlabels, &quot;&nbsp;&amp; _ 
&nbsp; &nbsp; &nbsp; &nbsp; &quot;(SELECT top 1 'true' FROM sfordfil_sql WHERE item_desc_2 LIKE 'export%') as inexport &quot;&nbsp;&amp; _ 
&nbsp; &nbsp; &nbsp; &nbsp; &quot;FROM sfordfil_sql &quot;&nbsp;&amp; _ 
&nbsp; &nbsp; &nbsp; &nbsp; &quot;ORDER BY ord_no DESC&quot; 
&nbsp; &nbsp; &nbsp; &nbsp; set rs3 = Conn.Execute(strSQL3) 
strSQL1 = &quot;SELECT * FROM labels WHERE sf_ord = &quot;&nbsp;&amp; rs(&quot;ord_no&quot;) &amp;&nbsp;&quot;&quot; 
set rs1 = Conn.Execute(strSQL1)%&gt; 
&lt;%if rs3(&quot;inlabels&quot;) = true and rs3(&quot;inexport&quot;) = true and rs1(&quot;zn_4&quot;) &gt;&nbsp;0 then %&gt; 
Test 1 Export 
&lt;%Else if rs3(&quot;inlabels&quot;) = true and rs3(&quot;inexport&quot;) = true and rs1(&quot;zn_4&quot;) = 0 then %&gt; 
Test 2 Export 
&lt;%Else if rs3(&quot;inexport&quot;) = true then %&gt; 
Test 3 Export 
&lt;%Elseif rs3(&quot;inlabels&quot;) = true and rs1(&quot;zn_4&quot;) &gt;&nbsp;0 then %&gt; 
Test 1 USA 
&lt;%Elseif rs3(&quot;inlabels&quot;) = true and rs1(&quot;zn_4&quot;) = 0 then %&gt; 
Test 2 USA 
&lt;%Else%&gt; 
Test 3 USA 
&lt;%End If%&gt; 
&lt;/font&gt;&lt;/b&gt;&lt;font size=&quot;1&quot;&gt;&lt;/font&gt;&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt; 
&lt;% rs.MoveNext %&gt; 
&lt;%end if%&gt; 
&lt;%end if%&gt; 
&lt;% Wend %&gt; 
 
EOF fix: 
&lt;% While Not rs.EOF %&gt; 

</div>

<div>
Running but still not doing the correct action: 
Another way to see if something is an export is the short Model # is a ***2** number. 
 
Shop Order # Short Model # Item Description Start Date Print 
3630 10202-LP &nbsp;Spa, w/Lounge 8' - Lapis &nbsp;4/28/2006 Test 3 USA &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&lt;--------Should be an Export 
3568 6100-SG &nbsp;Spa, w/Lounge 6' - Sage &nbsp;4/28/2006 Test 3 USA &nbsp; 
3382 6100-PR &nbsp;Spa, w/Lounge 6' - Pearl &nbsp;4/28/2006 Test 3 USA &nbsp; 
 
Code: 
&lt;%'DECLARATIONS 
dim dia, strID, strSQL, Conn, rs, strSQL2, strSQL3, strSQL4, strSQL5, rs2, rs3, rs4, rs5, ordno 
dia = Date() 
strSQL = &quot;SELECT * FROM sfordfil_sql WHERE compl_dt is NULL ORDER BY ord_no DESC&quot; 
set rs = Conn.Execute(strSQL) 
strSQL3 = &quot;SELECT *, &quot;&nbsp;&amp; _ 
&nbsp; &nbsp; &nbsp; &nbsp; &quot;(SELECT top 1 'true' FROM labels WHERE job_no = &quot;&nbsp;&amp; rs(&quot;ord_no&quot;) &amp;&nbsp;&quot;) as inlabels, &quot;&nbsp;&amp; _ 
&nbsp; &nbsp; &nbsp; &nbsp; &quot;(SELECT top 1 'true' FROM sfordfil_sql WHERE item_desc_2 LIKE 'export%') as inexport &quot;&nbsp;&amp; _ 
&nbsp; &nbsp; &nbsp; &nbsp; &quot;FROM sfordfil_sql &quot;&nbsp;&amp; _ 
&nbsp; &nbsp; &nbsp; &nbsp; &quot;ORDER BY ord_no DESC&quot; 
&nbsp; &nbsp; &nbsp; &nbsp; set rs3 = Conn.Execute(strSQL3) 
strSQL1 = &quot;SELECT * FROM labels WHERE sf_ord = &quot;&nbsp;&amp; rs(&quot;ord_no&quot;) &amp;&nbsp;&quot;&quot; 
set rs1 = Conn.Execute(strSQL1)%&gt; 
&lt;% While Not rs.EOF %&gt; 
&nbsp; &nbsp; &nbsp;&lt;tr&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td width=&quot;109&quot; align=&quot;center&quot;&gt;&lt;%= rs(&quot;ord_no&quot;) %&gt;&lt;/td&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td width=&quot;130&quot; align=&quot;center&quot;&gt;&lt;%= rs(&quot;item_no&quot;) %&gt;&lt;/td&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td width=&quot;208&quot; align=&quot;center&quot;&gt;&lt;%= rs(&quot;item_desc_1&quot;) %&gt;&lt;/td&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td width=&quot;128&quot; align=&quot;center&quot;&gt;&lt;%= rs(&quot;start_dt&quot;) %&gt;&lt;/td&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td width=&quot;136&quot; align=&quot;center&quot;&gt; 
&lt;%if rs3(&quot;inlabels&quot;) = true and rs3(&quot;inexport&quot;) = true and rs1(&quot;zn_4&quot;) &gt;&nbsp;0 then %&gt; 
Test 1 Export 
&lt;%Elseif rs3(&quot;inlabels&quot;) = true and rs3(&quot;inexport&quot;) = true and rs1(&quot;zn_4&quot;) = 0 then %&gt; 
Test 2 Export 
&lt;%Elseif rs3(&quot;inexport&quot;) = true then %&gt; 
Test 3 Export 
&lt;%Elseif rs3(&quot;inlabels&quot;) = true and rs1(&quot;zn_4&quot;) &gt;&nbsp;0 then %&gt; 
Test 1 USA 
&lt;%Elseif rs3(&quot;inlabels&quot;) = true and rs1(&quot;zn_4&quot;) = 0 then %&gt; 
Test 2 USA 
&lt;%Else%&gt; 
Test 3 USA 
&lt;%End If%&gt; 
&lt;/font&gt;&lt;/b&gt;&lt;font size=&quot;1&quot;&gt;&lt;/font&gt;&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt; 
&lt;% rs.MoveNext %&gt; 
&lt;% Wend %&gt; 
&lt;/table&gt;&lt;/div&gt;
</div>

<div>
Looks like the export query is not working.
</div>

<div>
can you try running this query in sql to see that we are getting the correct values at least there? &nbsp;im wondering if we need to tweak that query a bit.
</div>

<div>
SELECT &nbsp; &nbsp; * 
FROM &nbsp; &nbsp; &nbsp; &nbsp; sfordfil_sql 
WHERE &nbsp; &nbsp; (item_desc_2 LIKE 'export%') 
 
Here is a Sample of the output. 
 
1343 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;7200-PR &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;4/28/2006 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1343 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Spa, w/Lounge 7' - Pearl &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Export &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
3545 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;7202-PL &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;4/28/2006 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3545 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Spa, w/Lounge 7' - Platinum &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Export w/Stereo &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
3626 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;6200-LP &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;4/28/2006 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3626 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Spa, w/Lounge 6' - Lapis &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Export &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
3628 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;10202-LP &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;4/28/2006 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3628 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Spa, w/Lounge 8' - Lapis &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Export w/Stereo &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
3629 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;10202-LP &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;4/28/2006 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3629 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Spa, w/Lounge 8' - Lapis &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Export w/Stereo &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
3630 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;10202-LP &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;4/28/2006 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3630 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Spa, w/Lounge 8' - Lapis &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Export w/Stereo &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
44 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;10200-LP &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;4/28/2006 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;44 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Spa, w/Lounge 8' - Lapis &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Export &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
45 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;10200-LP &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;4/28/2006 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;45 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Spa, w/Lounge 8' - Lapis &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Export &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
 
This is what i can put into SQL dirrect and get a list.
</div>

<div>
do you need to do the same thing with the labels query?
</div>

<div>
what about this? When it returns the results it checks to see if export is in the &quot;item_desc_2&quot;. &nbsp;I get an error: 
Microsoft VBScript runtime error '800a0023' 
Sub or Function not defined 
/finial/4.asp, line 40 
 
 
dim dia, strID, strSQL, Conn, rs, strSQL2, strSQL3, strSQL4, strSQL5, rs2, rs3, rs4, rs5, ordno 
dia = Date() 
strSQL = &quot;SELECT * FROM sfordfil_sql WHERE compl_dt is NULL ORDER BY ord_no DESC&quot; 
set rs = Conn.Execute(strSQL) 
strSQL1 = &quot;SELECT * FROM labels WHERE sf_ord = &quot;&nbsp;&amp; rs(&quot;ord_no&quot;) &amp;&nbsp;&quot;&quot; 
set rs1 = Conn.Execute(strSQL1)%&gt; 
&lt;% While Not rs.EOF %&gt; 
&nbsp; &nbsp; &nbsp;&lt;tr&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td width=&quot;109&quot; align=&quot;center&quot;&gt;&lt;%= rs(&quot;ord_no&quot;) %&gt;&lt;/td&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td width=&quot;130&quot; align=&quot;center&quot;&gt;&lt;%= rs(&quot;item_no&quot;) %&gt;&lt;/td&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td width=&quot;208&quot; align=&quot;center&quot;&gt;&lt;%= rs(&quot;item_desc_1&quot;) %&gt;&lt;/td&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td width=&quot;128&quot; align=&quot;center&quot;&gt;&lt;%= rs(&quot;start_dt&quot;) %&gt;&lt;/td&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td width=&quot;136&quot; align=&quot;center&quot;&gt; 
&lt;%if rs(&quot;item_desc_2&quot;) like &quot;'export%'&quot; and rs1(&quot;zn_4&quot;) &gt;&nbsp;0 then %&gt; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&lt;----- Line with Error 
Test 1 Export 
&lt;%Elseif rs(&quot;item_desc_2&quot;) like &quot;'export%'&quot; and rs1(&quot;zn_4&quot;) = 0 then %&gt; 
Test 2 Export 
&lt;%Elseif rs(&quot;item_desc_2&quot;) like &quot;'export%'&quot; then %&gt; 
Test 3 Export 
&lt;%Elseif rs1(&quot;zn_4&quot;) &gt;&nbsp;0 then %&gt; 
Test 1 USA 
&lt;%Elseif rs1(&quot;zn_4&quot;) = 0 then %&gt; 
Test 2 USA 
&lt;%Else%&gt; 
Test 3 USA 
&lt;%End If%&gt; 
&lt;/font&gt;&lt;/b&gt;&lt;font size=&quot;1&quot;&gt;&lt;/font&gt;&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt; 
&lt;% rs.MoveNext %&gt; 
&lt;% Wend %&gt; 
&lt;/table&gt;&lt;/div&gt; 

</div>

<div>
nope that doesnt work like that. &nbsp;can you try that query i gave you? &nbsp;i believe that is the problem we were facing. &nbsp;what was happening was that for every model, it was retrieveing only the first record which wasnt in the export table. &nbsp;by relating the model it pulls only the record for that model.
</div>

<div>
Ok I found it.... This works: 
 
&lt;% &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
strSQL3 = &quot;SELECT * FROM sfordfil_sql WHERE item_desc_2 LIKE 'export%' and ord_no = &quot;&nbsp;&amp; rs(&quot;ord_no&quot;) &amp;&nbsp;&quot;&quot; 
set rs3 = Conn.Execute(strSQL3) %&gt; 
&lt;%if rs3.EOF and rs1(&quot;zn_4&quot;) &gt;&nbsp;0 then %&gt; 
Test 1 USA 
&lt;%Elseif rs3.EOF and rs1(&quot;zn_4&quot;) = 0 then %&gt; 
Test 2 USA 
&lt;%Elseif rs3.EOF then %&gt; 
Test 3 USA 
&lt;%Elseif rs1(&quot;zn_4&quot;) &gt;&nbsp;0 then %&gt; 
Test 1 Export 
&lt;%Elseif rs1(&quot;zn_4&quot;) = 0 then %&gt; 
Test 2 Export 
&lt;%Else%&gt; 
Test 3 Export 
&lt;%End If%&gt; 
&lt;/font&gt;&lt;/b&gt;&lt;font size=&quot;1&quot;&gt;&lt;/font&gt;&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt; 
&lt;% rs.MoveNext %&gt; 
&lt;% Wend %&gt;
</div>

<div>
<div class="content wysiwyg-content">
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 
6100-LP 
6100-MC 
6100-PL 
6100-PR 
6100-SG 
7100-LP 
7100-MC 
7100-PL 
7100-PR 
7100-SG 
7102-LP 
7102-MC 
7102-PL 
7102-PR 
7102-SG 
8100-LR 
8100-MC 
8100-PL 
8100-PR 
8100-SG 
8102-LP 
8102-MC 
8102-PL 
8102-PR 
8102-SG 
10100-LP 
10100-MC 
10100-PL 
10100-PR 
10100-SG 
10102-LP 
10102-MC 
10102-PL 
10102-PR 
10102-SG 
 
Model Numbers for CE 
6200-LP 
6200-MC 
6200-PL 
6200-PR 
6200-SG 
7200-LP 
7200-MC 
7200-PL 
7200-PR 
7200-SG 
7202-LP 
7202-MC 
7202-PL 
7202-PR 
7202-SG 
8200-LR 
8200-MC 
8200-PL 
8200-PR 
8200-SG 
8202-LP 
8202-MC 
8202-PL 
8202-PR 
8202-SG 
10200-LP 
10200-MC 
10200-PL 
10200-PR 
10200-SG 
10202-LP 
10202-MC 
10202-PL 
10202-PR 
10202-SG 
 
Plus I need it to still check to see if record exist in the label table, and if the value is &gt;&nbsp;0. 
This is what I have right now but it does not look at the model numbers: 
&lt;% 
&nbsp; &nbsp; &nbsp;strSQL2 = &quot;SELECT * FROM labels WHERE sf_ord = &quot;&nbsp;&amp; rs(&quot;ord_no&quot;) 
&nbsp; &nbsp; &nbsp;set rs2 = Conn.Execute(strSQL2) 
if rs2.BOF AND rs2.EOF then%&gt;&lt;b&gt;&lt;font size=&quot;4&quot;&gt; 
&lt;a target=&quot;_blank&quot; href=&quot;labelprint.asp?ordno=&lt;%= rs(&quot;ord_no&quot;) %&gt;&quot;&gt;Print First&lt;/a&gt; 
 
&lt;%Elseif &nbsp;rs2(&quot;zn_4&quot;) = 0 then %&gt;&lt;/font&gt;&lt;/b&gt; &lt;b&gt; 
&lt;font size=&quot;4&quot;&gt; 
&lt;a target=&quot;_blank&quot; href=&quot;labelprint.asp?ordno=&lt;%= rs(&quot;ord_no&quot;) %&gt;&quot;&gt;Print First&lt;/a&gt; 
&lt;/font&gt;&lt;font size=&quot;2&quot;&gt; 
 
&lt;%Elseif &nbsp;rs2(&quot;zn_4&quot;) &gt;&nbsp;0 then %&gt;&lt;/font&gt;&lt;/b&gt; &lt;b&gt; 
&lt;a target=&quot;_blank&quot; href=&quot;labelprint.asp?ordno=&lt;%= rs(&quot;ord_no&quot;) %&gt;&quot;&gt;&lt;font size=&quot;1&quot;&gt;Completed&lt;/font&gt;&lt;/a&gt;&lt;font size=&quot;1&quot;&gt; 
 
&lt;%End If%&gt; 

</div>
</div>

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
6100-LP
6100-MC
6100-PL
6100-PR
6100-SG
7100-LP
7100-MC
7100-PL
7100-PR
7100-SG
7102-LP
7102-MC
7102-PL
7102-PR
7102-SG
8100-LR
8100-MC
8100-PL
8100-PR
8100-SG
8102-LP
8102-MC
8102-PL
8102-PR
8102-SG
10100-LP
10100-MC
10100-PL
10100-PR
10100-SG
10102-LP
10102-MC
10102-PL
10102-PR
10102-SG

Model Numbers for CE
6200-LP
6200-MC
6200-PL
6200-PR
6200-SG
7200-LP
7200-MC
7200-PL
7200-PR
7200-SG
7202-LP
7202-MC
7202-PL
7202-PR
7202-SG
8200-LR
8200-MC
8200-PL
8200-PR
8200-SG
8202-LP
8202-MC
8202-PL
8202-PR
8202-SG
10200-LP
10200-MC
10200-PL
10200-PR
10200-SG
10202-LP
10202-MC
10202-PL
10202-PR
10202-SG

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%>
<a target="_blank" href="labelprint.asp?ordno=<%= rs("ord_no") %>">Print First</a>

<%Elseif rs2("zn_4") = 0 then %> 

<a target="_blank" href="labelprint.asp?ordno=<%= rs("ord_no") %>">Print First</a>


<%Elseif rs2("zn_4") > 0 then %> 
<a target="_blank" href="labelprint.asp?ordno=<%= rs("ord_no") %>">Completed</a>

<%End If%>

Check value of model number then do something based on that

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.