Recordset Weird Problem

HI Friends,
I am facing a very weird problem. I had worked on a site which was working fine, but due to client's request, i had to reload the data in the db. After data migration, i started facing a strange problem, suddently values for some of the fields were not being displayed in the asp page, i checked up the sql query used, ran the same query in query analyzer and found that the values for the fields that were not appearing on the asp page were there in the db. This really confused me, i tried lots of different things. And finally tried using
Things started to work well now.

Now the question arises why did this happened. Can anyone please explain me a bit. I would really appreciate to hear your views.

Thanking You

I think since you imported the data again into the database, your Recordset was out of date with the old database so using the Resync method allows you to refresh the data in your Recordset. You probably want to leave this in your code so when you make new database changes, it'll refresh automatically for you.