moved site and asp now pages show sql records twiceTWICE !!

Hey,

We've just moved our site from a Win 2000 server to Win 2003. Some of the pages on the site pick up data from a couple of sql d/bs.

Pages that display data from d/bA are fine - BUT - pages that use d/bB now display each record twice !! Examples of what I mean are at: http://www.southwark.ac.uk/events_0702.asp

Needless to say I haven't touched any of the code !!

We did have a few problems getting the site running on the new server to start with - kept getting user login fail messages !! We managed to sort those out and there are no significant differences between the two databases.

Anyone have any idea what's going on ? We're using SQL 2000 with SP3 and the d/bs sit on the same box as the site.

Thanks,
Gabrielle

Are there duplicate records in the database?

No - that was the first thing I checked.

Step through your code. It is probably looping twice.

Ok thanks - I'll try that.

Have looked at the code on one of the offending pages but I can't see why it would loop twice.


<%
Set articles = getAllArticles()
if not articles.EOF then
while not articles.EOF
%>
<tr>
<td class="entry"><%=trim(articles("ARTICLEDATE"))%></td>
<td class="entry"><%=trim(articles("TITLE"))%></td>
</tr>
<%
articles.moveNext
wend
end if
%>

Any ideas ?