[FX.php List] AddSortParam line shows 0 records

Tim 'Webko' Booth tim at nicheit.com.au
Wed Jan 11 20:59:14 MST 2012


On 12/01/2012, at 2: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();

echo "Error: ".$q['errorCode'];

I'm betting that the field is not on the layout, so it can't sort on  
it...

Cheers

T


More information about the FX.php_List mailing list