Loop through records- stop if certain value met

SoC · July 28th, 2005, 02:51 AM

Hi,

I have a little problem with a loop. I have a little script that will show a small flash movie if a record contains a certain value.

The problem with my code is that if there is more than one record that equals that value, more flash movies will be shown.

I only want one to show. Here is my dodgy code:

Code:

<%While not rsNews.eof
If rsNews.Fields.Item("dateAdded").Value = theDate then%>
<object>My Flash movie code here
            </object>
<%end if%>
<%
rsNews.movenext()
Wend%>

I haven't really used loops before, so if someone could please explain it would be great.

thanks

s

ChrisScott · July 28th, 2005, 03:32 AM

Hey s,

Try changing the loop to a Do...Loop structure and using the Exit Do statement...

Code:

<%
Do Until rsNews.eof
    If rsNews.Fields.Item("dateAdded").Value = theDate Then
        %>
        <object>My Flash movie code here</object>
        <%
        Exit Do
    End If
    rsNews.movenext()
Loop
%>

HTH,

Chris

SoC · July 28th, 2005, 08:22 PM

Yes, that's perfect. Thanks very much Chris