[FX.php List] AddSortParam line shows 0 records

[Dale Bengston]

Hang on, naturally it's the web browser that's encoding the text to display it when you echo the URL to the browser page. View source and copy the url from the page source, not the page itself and you should get the actual characters in the URL.

Dale

On Jan 12, 2012, at 11:02 AM, Dale Bengston wrote:

> Hi Denis,
> 
> The url encoding for a quote character is ". So, it looks like something along the way is url-decoding the characters &quot and inserting a quote character " in its place, which is blowing up the URL.
> 
> So, the trick will be to find where the URL is getting decoded.
> 
> Hope this helps,
> 
> Dale
> 
> 
> 
>  --
> Dale Bengston
> Streamline Studio, LLC
> www.streamline-studio.com
> 
> On Jan 12, 2012, at 8: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
> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.iviking.org/pipermail/fx.php_list/attachments/20120112/adf917a7/attachment-0001.html