Apologies if this has been looked at before, but I couldn't find it anywhere.

We use the WPE for XML publishing, passing queries with various data for searching and sorting etc. An example of this is for current news items on our website, with a querystring like this to get the three latest news items...

&published_date=10%2F31%2F2006&published_date.op=lte&type=latestnews&type.op=eq&-max=3&-sortfield.1=published_date&-sortorder.1=descend&-find  

This works fine, but sometimes FileMaker stops sorting all together, and just returns the first three records in the database.

When it happens, this affects all databases on the server, and affects any sort options...we sort other things alphabetically and they stop sorting as well.

Any suggestions or help appreciated,

Cheers,

Sean

Andy Gaunt of fmpug.com has reported this issue.

To add to the data points:

Are you on a Windows or Mac server? What hardware and OS specs? FMSA version?

- John

The server is windows 2003 server standard edition SP1. I dont know a lot of details...it is a rack mountable server with a RAID array, processor is a XEON 3.2ghx, 2gigs of RAM. Beyond that, I'm not too sure.

FMSA is version 8.0. (See http://www.fmforums.com/forum/showtopic.php?tid/180924/ for why we dont have the v4 updates!)

Cheers,

Sean