[FX.php List] AddSortParam line shows 0 records

Denis Somar dsomar at gmail.com
Wed Jan 11 21:10:13 MST 2012


It is on the layout, errorCode returns 5 = Command is invalid.

This I do not know why!

On Wed, Jan 11, 2012 at 10:59 PM, Tim 'Webko' Booth <tim at nicheit.com.au>wrote:

>
> 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
> ______________________________**_________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/**mailman/listinfo/fx.php_list<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/20120111/bb2ac4b7/attachment.html


More information about the FX.php_List mailing list