[FX.php List] Convoluted scheme for creating summaries

[Dale Bengston]

Aha, I didn't realize that FX had its own default. I have always  
specified my own, so I've never tried it without a third parameter to
$request->SetDBData('database', 'layout', 'all');

Dale


On Aug 21, 2006, at 10:15 PM, Andy Gaunt wrote:

> 50 is the default for the dataset returned by FX. This is set by FX  
> not the php.ini
>
>
>
> However you can manually specify a value here or as Dan states set  
> it to all to display ALL records that match the request.
>
>
>
> Andy Gaunt
>
> Office: 321.206.3658
>
> Mobile: 407.810.4722
>
> andy at fmpug.com
>
> http://www.fmpug.com
>
>
>
> 2006 FileMaker Excellence Award Winner
>
> Recipient of FileMaker’s 2005 “Mad Dog” Public Relations Award
>
>
>
> For chapter locations, dates & times please visit the website at  
> http://www.fmpug.com If you can make it to a meeting, please RSVP  
> at http://www.fmpug.com/rsvp.php
>
>
>
> From: fx.php_list-bounces at mail.iviking.org [mailto:fx.php_list- 
> bounces at mail.iviking.org] On Behalf Of Bob Patin
> Sent: Monday, August 21, 2006 11:05 PM
> To: FX.php Discussion List
> Subject: Re: [FX.php List] Convoluted scheme for creating summaries
>
>
>
> Yes, but can't you only display 50 at a time?
>
>
>
>
>
> On Aug 21, 2006, at 8:54 AM, DC wrote:
>
>
>
>
> no. there are no limits other than the one's you impose on yourself!
>
>
>
> $request->SetDBData('database', 'layout','all');
>
>
>
> the third parameter is the groupsize. 'all' tells FX.php to grab  
> every record that matches the search.
>
>
>
> dan
>
>
>
> On Aug 21, 2006, at 9:47 AM, Alex Gates wrote:
>
>
>
>
> Isn’t the 50 limit set in php.ini?
>
>
>
> Alex P. Gates
>
>
>
>
> If this email is spam, report it here:
> http://www.OnlyMyEmail.com/ReportSpam -----Original Message-----
> From: fx.php_list-bounces at mail.iviking.org [mailto:fx.php_list- 
> bounces at mail.iviking.org] On Behalf Of Bob Patin
> Sent: Monday, August 21, 2006 8:44 AM
> To: FX.php Discussion List
> Subject: Re: [FX.php List] Convoluted scheme for creating summaries
>
>
>
>
>
> On Aug 20, 2006, at 10:47 PM, DC wrote:
>
>
>
>
>
>> the found set is limited to 50 records
>>
>
>
> why is the found set limited? can't you just set the groupsize to all?
>
>
>
> I thought 50 was the maximum for FX? Is that not the case?
>
>
>
>
>
> in any case, if you can lift your groupsize restrictions, you might  
> be able send your full FX result array it into this little machine  
> to get what you want:
>
>
>
> http://www.dbmscan.com/snippets/index.php?cat_select=FX_helpers
>
>
>
> see the new one called: Summarize field values in FX result array
>
>
>
> Thanks, I'll check it out...
>
>
>
> Bob Patin
>
> Longterm Solutions
>
> bob at longtermsolutions.com
>
> 615-333-6858
>
> http://www.longtermsolutions.com
>
>
>
>   CONTACT US VIA INSTANT MESSAGING:
>
>      AIM or iChat: longterm1954
>
>      Yahoo: longterm_solutions
>
>      MSN: tech at longtermsolutions.com
>
>      ICQ: 159333060
>
>
>
>
>
>
>
> _______________________________________________
>
> 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
>
>
>
>
>
>
>
> --
>
> If this email is spam, report it here:
>
> http://www.OnlyMyEmail.com/reportSpam? 
> Id=NDIyMTM6MTU3MjE5NDQ0OmJvYkBwYXRpbi5jb20%3D
>
>
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list