[FX.php List] records search limit?

[Andy Gaunt]

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
_______________________________________________
FX.php_List mailing list
FX.php_List at mail.iviking.org
http://www.iviking.org/mailman/listinfo/fx.php_list