[FX.php List] Problem with AddSortParam

[Dale Bengston]

Hi Chris,

GET would probably encode slashes in dates, but that affects the  
values of fields. Since you're passing the field name as a sort  
parameter, the values of that field are not passed in the GET. Hmm.  
Have you looked at the obvious stuff, like is that date field really  
defined as a date field in FMP? Is it on the layout being referenced  
by FX?

Hope this helps,
Dale

On Oct 4, 2006, at 2: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