I have a script that performs a search and displays the results in a columnar list. it works great until I sort it by date. After that, about half of the records disapear. I have tried sorting from within the browser as well as through the script, same results. Any ideas?

I'd guess that some of your fields are on subsummary parts, which only appear when sorted by a specified field. Go to Layout mode and see if that's it.

Thanks for the response. I checked and there is only one part on the layout which is Body. After working on this a bit more, I have discovered that records with dates prior to 2008 are omitted form view and only on the web.

FMP client displays everything correctly. I am checking through all of my scripts again to see if there is something wrong...

OK, I figured it out. I just had to add a "goto record first" step in the script to "refresh" the results after the sort and it worked fine!