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:
<%While not rsNews.eof
If rsNews.Fields.Item("dateAdded").Value = theDate then%>
<object>My Flash movie code here
I haven't really used loops before, so if someone could please explain it would be great.