[FX.php List] AddSortParam line shows 0 records

[BEVERLY VOTH]

I always put the sort after the query fields, but I don't know if that makes a difference.

Is the SORT FIELD on the layout called? Is the name the same as a "custom sort by value list"? Does the sort field have a value list assigned to it? Again, I don't know if that makes a difference, but these are the things I look for when debugging.

And lastly, did you try assigning the sort order of "Ascend, Descend, or Custom"? I found out the hard way that this should not be quoted.

Beverly

On 11 Jan 2012, at 10:50 PM, Denis Somar wrote:

> Hi all,
> 
> I have a simple issue/question on OS X.7, running FM11SA.  I have a query which works perfectly BUT when I add a line with AddSortParam, the code suddenly returns 0 records.  I've tried retyping it and can't think what the issue might be - any ideas or experiences with this?
> 
> 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();
> 
> As always, thanks in advance.
> 
> Denis
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list