[FX.php List] AddSortParam line shows 0 records

[BEVERLY VOTH]

Bob, when I tried Ascend with the single quotes, it broke for me. What's the correct syntax?

Beverly

On 13 Jan 2012, at 11:03 AM, Bob Patin wrote:

> Denis,
> 
> Here's what you had in your original post:
> 
> Here's the code for arg's sake:
> $q->SetDBUserPass( $webUN, $webPW );
> $q->SetDBData( $webDB, 'Quotes_Lines_layout' );
> $q->AddSortParam('quote_id');         //<<<<<<<<<<<<<<<<<<<<< THIS IS THE LINE THAT BORKS EVERYTHING
> $q->AddDBParam( 'Quotes_lines to quotes::user_id', $_SESSION[$pKey]['id'] );
> $q->AddDBParam( 'quote_id', $_GET["id"] );
> $r = $q->FMFind();
> 
> I see 2 things wrong with this code:
> 
> $q->SetDBUserPass( $webUN, $webPW );
> 
> That's backwards; specify the password first, like this:
> 
> $q->SetDBUserPass( $webPW , $webUN );
> ----------------
> 
> Second, you didn't specify what your sortParam is and this is what is probably breaking things as well; try this
> 
> $q->AddSortParam('quote_id' , 'ascend' );
> 
> 
> Bob Patin
> Longterm Solutions LLC
> bob at longtermsolutions.com
> 615-333-6858
> http://www.longtermsolutions.com
> FileMaker 9, 10 & 11 Certified Developer
> Member of FileMaker Business Alliance and FileMaker TechNet
> --
> Twitter: bobpatin
> Google+: http://www.longtermsolutions.com/plus
> AIM: longterm1954
> iChat: bobpatin
> --
> Expert FileMaker Consulting 
> FileMaker Hosting for all versions of FileMaker
> 
> 
> On Jan 12, 2012, at 11:38 PM, Denis Somar wrote:
> 
>> To further the mystery, I tried sorting on another page that works perfectly and it also borks with error 5 but no malformed URL
>> 
>> I tried reinstalling FX.php in case I had done something with it and still no luck.
>> 
>> I'm now officially at a complete loss, oy...
>> 
>> D
>> 
>> On Thu, Jan 12, 2012 at 4:29 PM, Troy Meyers <tcmeyers at troymeyers.com> wrote:
>> Denis,
>> 
>> Has anyone suggested, or have you tried, just renaming the FileMaker field quote_id to something different, such as qote_id (and of course changing the instances in PHP) to see if that magically cures the problem?
>> 
>> -Troy
>> 
>> _______________________________________________
>> 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
> 
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list