[FX.php List] records search limit?

[Dana Benciu]

Thanks for all the answers, it worked beautifully!

Dana.

Andy Gaunt wrote:
> Dana,
>
> The default returned record set is limited to a default of 50.
>
> You need to change the group size.
>
> I would first create a variable for the group size
>
> $groupSize='xxxx';
>
> And then append the group size to the SetDBData function as the last
> optional parameter.
>
> $query -> SetDBData($webDB,$searchLayout,$groupSize);
>
> Note that groupSize can be a value such as 1, 50,100,5000 or you can enter
> all (in lowercase) to return all the found records.
>
> HTH
>
> 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
>
>
> -----Original Message-----
> From: fx.php_list-bounces at mail.iviking.org
> [mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Dana Benciu
> Sent: Tuesday, October 31, 2006 3:34 PM
> To: FX.php Discussion List
> Subject: [FX.php List] records search limit?
>
> Hi all,
>
> I am not sure if this subject was previously discussed, but I am having 
> some difficulties displaying all the found records based on a search 
> criteria. I am using a very simple code, something like:
>
> ...
> $DatasetQuery->AddDBParam('receiving_funding', 'Now');
> $DatasetQuery->AddDBParam('language_correspondence', 'French');
> $result = $DatasetQuery->FMFind();
>
> if ($result['foundCount'] == 0) {
>   echo "No records matched your selection. Please try again";
> }
> else {
>   echo "foundCount: ".$result['foundCount']."<br>\n";
>
>   foreach ($result['data'] as $recordKey=>$recordData) {
>     $last_name = $recordData['last_name'][0];
>     $first_name = $recordData['first_name'][0];
>   }
> }
>
> When I print $result['foundCount'] I am getting an amount something like 
> 65, but there is no way I can print after that the first_name and 
> last_name fields of more than 50 records. Does anyone have any idea why 
> this might happen?
>
> Thanks,
> Dana.
>
>   

-- 
Dana Benciu
Web and IT Coordinator
Association for Women's Rights in Development (AWID)
215 Spadina Avenue, Suite 150
Toronto, Ontario Canada M5T 2C7
tel: (+1) 416-594-3773 fax: (+1) 416-594-0330
dbenciu at awid.org  --- http://www.awid.org