Search results dissapear after sort...

[genr8er]

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?

[Fitch]

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.

[genr8er]

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...

[genr8er]

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!