[FX.php List] AddSortParam line shows 0 records

[Bob Patin]

Not sure what you mean, but I always include the data file at the top of pages

include_once('FX/my_data.php")

(or whatever it's named in my solutions)

can you send the code you tried? If you get a blank page, you probably have a parsing error; did you try echoing anything back or PRINTing to the screen?

if an ECHO after the query doesn't return anything at all, try doing something like:

echo 'Error: '.$r['errorCode'];

You should *at least* see the word "Error," even if the query fails, assuming there isn't a parse error.

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:53 AM, Denis Somar wrote:

> I did try swapping the UN and PW and I get a blank page subsequently with a blank viewsource page.  I think it may have to do with including server_data.php directly or whether it's because it is called from a secondary include?  I'm not sure.
> 
> D
> 
> On Fri, Jan 13, 2012 at 11:40 AM, Bob Patin <bob at patin.com> wrote:
> 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
>> 
>> 
> 
> 
> _______________________________________________
> 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/20120113/42cef552/attachment.html