[FX.php List] AddSortParam line shows 0 records

[Bob Patin]

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.iviking.org/pipermail/fx.php_list/attachments/20120113/6caedd15/attachment-0001.html