[FX.php List] AddSortParam line shows 0 records

[Steven Thoms]

Denis,

I like to debug in the browser sometimes. Try echoing:

echo $r['URL'];

Take that value and put it in the location bar of a browser and run it  
directly. This will give you the raw xml result that FX processed to  
create your result array. It may not show much. Could you also post  
the URL? That way we might see what commands were sent. If you posted  
the raw xml as well that might be informative.

Steve
207 798-0171

On Jan 11, 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