[FX.php List] AddSortParam not working

[Andy Gaunt]

Hi everyone,

Seems this little issue keeps rearing its ugly little head and may be
another issue still with the FX.PHP running on FMS8A.


If you are using FX.PHP and running FMS8A please let us know if you have any
issues with scripts ignoring your Sort settings.

This only applies if you use the 

$query -> AddSortParam('Your Field','sort order');

This is an intermittent issue which appears to resolve itself after a period
of time (anywhere from 1-several hours). We are right now running a looping
test on the FMPug website to see if we can find a pattern. We are capturing
the array data returned to FX.PHP after a query attempting to sort a set of
records in ascending order.

So far we have seen the issue on Windows Server based machines. If you do
have any issues, please let us know along with your server machine spec.

Andy Gaunt
T: 407.810.4722
andy at fmpug.com
http://www.fmpug.com    

Recipient of FileMaker's 2005 "Mad Dog" Public Relations Award

For chapter locations, dates & times please visit the website at
http://www.fmpug.com If you can make it to a meeting, please RSVP at
http://www.fmpug.com/rsvp.php


-----Original Message-----
From: fx.php_list-bounces at mail.iviking.org
[mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Dale Bengston
Sent: Thursday, February 23, 2006 11:39 PM
To: FX.php Discussion List
Subject: Re: [FX.php List] AddSortParam not working

Hi Stephen,

$try=new FX($serverIP,$webCompanionPort,'FMPro7');

or

$try=new FX($serverIP,$webCompanionPort);

instead of

$try=new FX($serverIP,$webCompanionPort,'FMPro8');

?

-Dale



On Feb 23, 2006, at 12:26 AM, Stephen Grant wrote:

> I am having the same problem that Andy reported.  FX + FM8..  It  
> appears to ignore the AddSortParam
>
>
>
> Has anyone else seen this?  Its now causing me substantial grief L
>
>
>
> Here is a snip of the PHP Code:
>
>
>
> include_once('FX/FX.php');
>
> include_once('FX/server_data.php');
>
>
>
> $productid=$_POST['productid'];
>
> $groupSize='50';
>
> $try=new FX($serverIP,$webCompanionPort,'FMPro8');
>
> $try->SetDBData('test.fp7','test',$groupSize);
>
> $try->SetDBPassword('','admin');
>
> $try->AddDBParam('productid',$productid);
>
> $try->AddSortParam('rank','ascend');
>
> $tryResult=$try->FMFind();
>
> echo $tryResult['errorCode'];
>
>
>
> The TEST database contains four numeric fields. Rank is one of  
> them. The resulting find returns the entry order and is not sorted.  
> Of course, if I specify a sort on an invalid field it blows up. So  
> the information appears to be being parsed over correctly but the  
> actual sort is not occurring.
>
>
>
> Help?
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list

_______________________________________________
FX.php_List mailing list
FX.php_List at mail.iviking.org
http://www.iviking.org/mailman/listinfo/fx.php_list