[FX.php List] AddSortParam line shows 0 records

[Denis Somar]

Thanks Beverly, but it didn't work and is still returning the same error.

Still stuck

Denis



On Jan 12, 2012, at 11:42 AM, BEVERLY VOTH <beverlyvoth at gmail.com> wrote:

> well! your original had:
> 
> $q->AddDBParam( 'quote_id', $_GET["id"] ); // double quotes
> 
> perhaps it's as simple as:
> 
> $q->AddDBParam( 'quote_id', $_GET['id'] ); // single quotes
> 
> I don't think it matters, but you never know... :)
> I'm a real stickler for consistency AND making sure that things like case are matched *exactly*.
> 
> Beverly
> 
> On 12 Jan 2012, at 9:17 AM, Denis Somar wrote:
> 
>> So I tried echo $r['URL'] and got the URL back and it is malformed:  
>> .../fmi/xml/FMPXMLRESULT.xml?-db=buzzerbeater&-lay=Quotes_Lines_layout&-max=50&Quotes_lines+to+quotes::user_id=1"e_id=1&-find
>> 
>> Note the id=1"e_id at the end which should read id=1?quote_id
>> 
>> But when I remove the AddSortParam, it is still malformed; however, if I type in the URL correctly, it responds with the proper XML.  What should I add in the URL to sort and what do you think about this?
>> 
>> THanks again for all your time everyone, your help has been invaluable!
>> 
>> Best,
>> Denis
>> 
>> 
>> 
>> On Thu, Jan 12, 2012 at 7:05 AM, Steven Thoms <sthoms at wavecomm.com> wrote:
>> 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
>> 
>> _______________________________________________
>> 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
> 
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list