[FX.php List] Convoluted scheme for creating summaries

[Bob Patin]

Dan,

Yes, I'd thought of that (I'm working in FM8, by the way), but the  
problem is that I have no way to know how many subsummary values I'll  
end up with any given report.

I wrote a test page that loops through the found set, counting up as  
the records are added to a table. Basicaqlly I wrote a little code  
that looks at the summary field; every time it changes from the  
previous loop, that means it's time to add a summary line to the  
table. This works fine, but my plan fell apart when I remembered that  
the found set is limited to 50 records, and sometimes these reports  
may have more than 50 records.

So I'd have to do a 2nd query, take the totals from the first 50, add  
them to the 2nd 50, and so on, until I had all my totals. I know this  
would work, but it's a huge pain to write it all.

I was hoping that someone would have faced this problem before and  
have a simpler solution.

I haven't delved into the FileMaker API yet; does it do anything that  
I can't do with FX.php? Like this, for example? I've gotten pretty  
comfortable in FX, and really don't want to switch unless there's a  
compelling reason to do so.

Thanks for your suggestion,


On Aug 20, 2006, at 10:03 PM, DC wrote:

> i think that if you make a calculated field in FMP with the  
> calculation getsummary() (off the top of my head) you should be  
> able to do it. my experience with that is that summary fields in  
> native FMP are slow. talking about FMP6 here.
>
> there's a nice array function in PHP called array_sum(). that might  
> help.
>
> dan
>
> On Aug 20, 2006, at 10:05 PM, Bob Patin wrote:
>
>> Better yet, is there a way to retrieve summary values in FX.php?
>
>
> If this email is spam, report it here:
> http://www.OnlyMyEmail.com/ReportSpam
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>
>
>
> --
> If this email is spam, report it here:
> http://www.OnlyMyEmail.com/reportSpam? 
> Id=NDIyMTM6MTU3MDc3NTg1OmJvYkBwYXRpbi5jb20%3D

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.iviking.org/pipermail/fx.php_list/attachments/20060820/ee133e8e/attachment.html