[FX.php List] Problem with AddSortParam

[Marisa Smith]

I had a recent sorting problem that was solved by stopping and  
starting the Filemaker server processes.  You might want to try that  
if you have admin access to your Filemaker Server.

On Oct 4, 2006, at 3:40 PM, Derrick Fogle wrote:

> Can you test a post for this find? That should tell you whether  
> it's a GET issue (which would amount to an encoding problem with  
> the slashes in the date), or a corrupted index in the FM database.  
> There have been problems with corrupted indexes in FM prior to the  
> latest 8.5 client. Another way to check the field index is to do  
> the find directly in the FM client. If you get screwy results that  
> way, you know what the problem is for sure.
>
> On Oct 4, 2006, at 2:35 PM, Chris Bisgard wrote:
>
>> Hi all,
>>
>> This is a strange problem, and I'm just not sure how to debug it.  
>> I have a fairly simple script that just lists events for any given  
>> date from a calendar database in FM8. I am trying to sort the  
>> results by date, but no matter what I do with AddSortParam, the  
>> results come up sorted by the -recid. Even if I try sorting by a  
>> text field instead of date, it still sorts by -recid.
>>
>> Incidentally, I have a similar script that queries another  
>> database on the same server, and it sorts everything fine. The  
>> only difference is that the query in the broken script comes from  
>> a GET function (hyper-linked from a little calendar table, so  
>> people can click the date they want), and the script that works  
>> properly uses POST data from a form. Would that have anything to  
>> do with it?
>>
>> I will post the entire script if anyone needs to see it, but  
>> mainly I was just hoping for some guidance on what to look for  
>> that moght be causing the AddSortParam function not to work. It  
>> seems big enough that I must be missing something obvious.
>>
>> Thanks in advance,
>> Chris Bisgard
>> _______________________________________________
>> FX.php_List mailing list
>> FX.php_List at mail.iviking.org
>> http://www.iviking.org/mailman/listinfo/fx.php_list
>
>
> Derrick Fogle
> derrick at fogles.net
>
>
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list