Help with recordset pleas

[shiggyshag]

Hi

I have a recoredset with two coloumns in one is boxnumber the other contents. box number is 1 to 90 ok and contenst could be blank or have text.

Now what I want to do is say display the contents from box number 18 to 37. how do i filter it so it only displays the records. I dont want to do this in the sql statement.

Cheers

 

[Cheech]

you could put some logic into your display


<table>
<%
Do while not rs.eof
If rs.Field(&quot;boxnumber&quot.value < 18 And > 37 Then
%>
<tr>
<td><%=rs.Contents%>
</td>
</tr>
<%
rs.movenext
next
%>

Or something along those lines The secret of life is honesty and fair dealing. If you can fake that, you've got it made.
Groucho Marx (1895-1977)