[FX.php List] Sorting Problem

[Chris Hansen]

Roger,

Nothing jumps out at me right away.  Could I have a look at the URL  
returned via DEBUG, as well as the XML that comes back from that URL?   
Feel free to send them back channel.  Best,

--Chris Hansen
   FileMaker 8 Certified Developer
   FileMaker 7 Certified Developer
   Creator of FX.php
   "The best way from FileMaker to the Web."
   www.iViking.org


On Jan 23, 2008, at 2:35 AM, Roger Price wrote:

> I have created a very simple prototype database with only 4 fields  
> and 6 or so records - nothing too taxing. However I cannot get it to  
> sort!
>
> member_id           (number)
> pub_category        (text, indexed)
> year_of_publication (text, indexed)
> pub_description     (text, indexed)
>
> My fx.php instance is as follows:
>
> $dbPub = 'pub2.fp7';
> $layPub = 'web';
> $PubQuery = new FX($serverIP, $webCompanionPort, $dataSourceType);
> $PubQuery ->SetDBData($dbPub, $layPub);
> $PubQuery ->AddDBParam('member_id','1');
> $PubQuery ->AddSortParam('pub_category','ascend',1);
> #$PubQuery ->AddSortParam('year_of_publication','ascend',2);
> #$PubQuery ->AddSortParam('pub_description','ascend',3);
> $PubQuery ->setDBUserPass($webUN);
> $PubData = $PubQuery->FMFind();
>
> As you can see I have commented out the secondary and tertiary sorts  
> in case they are causing the problem. I have tried using an FM  
> script to pre-sort the data but I cannot get this to work either. I  
> have other databases where the records sort as expected and cannot  
> see anything obviously different.
>
> I have turned on 'DEBUG' and display the contents of the array  
> $PubData (error = 0)!
>
> This is probably one of those situations where I am overlooking  
> something simple.
>
> Please can anyone offer a suggestion. I will post the content of  
> $PubData if it is needed.
>
> Roger Price
>
> ---------------------------------------------------------------------
> Roger Price                                  INSTITUTE OF CRIMINOLOGY
> Computer Officer,                                     Sidgwick Avenue
> rp272 at cam.ac.uk                                    Cambridge, CB3 9DT
> ---------------------------------------------------------------------
>
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list