[FX.php List] Accessing summary fields?
Dale Bengston
dbengston at preservationstudio.com
Mon Aug 21 08:05:32 MDT 2006
Hey Bob,
FX.PHP will return as many records as you ask it for, by including a
number or the word 'all' in the first parameter. I have summarized as
many as 12,000 records with FX... and that was using FMUv6. The
situation I was dealing with was summarizing invoice line items by
product by month by customer. I recall someone on this list was
processing even more records than this.
For a huge found set like this, it's key to use a layout that only
has the necessary fields. Also, you may have to increase the PHP
default timeout to make sure it doesn't give up while all that XML is
being retrieved. The shift in thinking is, often times the number of
records you're retrieving FX.PHP and processing with PHP can be far
greater than what you're displaying on the page.
Hope this helps,
Dale
On Aug 21, 2006, at 8:46 AM, Bob Patin wrote:
> Dale,
>
> That's what I did last night, and although it worked, my question
> was this:
>
> Isn't FX.php limited to displaying 50 records at a time? If so, how
> do I summarize the entire found set?
>
> Thanks,
>
> Bob
>
>
> On Aug 21, 2006, at 12:22 AM, Dale Bengston wrote:
>
>>
>>
>> Hi Bob,
>>
>> I generally just create my own summaries in PHP as I chew through
>> an array/found set. Works like a charm.
>>
>> Dale
>
> _______________________________________________
> 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://www.iviking.org/pipermail/fx.php_list/attachments/20060821/0579f7ae/attachment.html
More information about the FX.php_List
mailing list