[FX.php List] Problem with AddSortParam

[Derrick Fogle]

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