[FX.php List] AddSortParam line shows 0 records

[Bob Patin]

Denis,

Did you try swapping the placement of username and password? What you had in your email will definitely cause a failure.

Do you get anything back from FX when you do this?

echo $r['errorCode'];

If you don't then your query's not even running, which is exactly what a swapped un/pw would do.


Bob Patin
Longterm Solutions LLC
bob at longtermsolutions.com
615-333-6858
http://www.longtermsolutions.com
FileMaker 9, 10 & 11 Certified Developer
Member of FileMaker Business Alliance and FileMaker TechNet
--
Twitter: bobpatin
Google+: http://www.longtermsolutions.com/plus
AIM: longterm1954
iChat: bobpatin
--
Expert FileMaker Consulting 
FileMaker Hosting for all versions of FileMaker

On Jan 13, 2012, at 10:38 AM, Denis Somar wrote:

> So I did try using AddSortParam('quote_id', 'ascend') and it didn't work; however, in my newly constructed test file, I created the barest of html files, and ***managed to get it working***.  I'm still testing to see where the error is and I can't recreate it reliably, but I will send to the group once I finally figure this thing out.
> 
> To be continued, but thank you all kindly for all your continued brainstorming and help!!!!!!!!!!!!!!
> 
> Best,
> Denis
> 
> On Fri, Jan 13, 2012 at 11:15 AM, Bob Patin <bob at patin.com> wrote:
> Lower-case… :)
> 
> Single-quotes will work though…
> 
> >From my experience, placement of the command doesn't matter, although I almost always put things in the same order, so maybe I'm wrong. I always put
> 
> login
> search params
> sort params
> skip param (if any)
> 
> so maybe I just never noticed it (but I don't think so).
> 
> Chris is probably lurking about, maybe he can give us the definitive answer…
> 
> BP
> 
> 
> Bob Patin
> Longterm Solutions LLC
> bob at longtermsolutions.com
> 615-333-6858
> http://www.longtermsolutions.com
> FileMaker 9, 10 & 11 Certified Developer
> Member of FileMaker Business Alliance and FileMaker TechNet
> --
> Twitter: bobpatin
> Google+: http://www.longtermsolutions.com/plus
> AIM: longterm1954
> iChat: bobpatin
> --
> Expert FileMaker Consulting
> FileMaker Hosting for all versions of FileMaker
> 
> On Jan 13, 2012, at 10:12 AM, BEVERLY VOTH wrote:
> 
> > Bob, when I tried Ascend with the single quotes, it broke for me. What's the correct syntax?
> >
> > Beverly
> 
> 

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