[FX.php List] records search limit?

Tom Sepper tsepper at dctandt.com
Tue Oct 31 13:42:03 MST 2006


The FX default is a 50-record found set unless otherwise specified. 


---
Tom Sepper
Director of Information Technology
Director's Choice Tour & Travel

P 806.762.6354
F 806.763.7637

tsepper at dctandt.com
www.directorschoicetourandtravel.com

-----Original Message-----
From: fx.php_list-bounces at mail.iviking.org
[mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Alex Gates
Sent: Tuesday, October 31, 2006 2:38 PM
To: 'FX.php Discussion List'
Subject: RE: [FX.php List] records search limit?

Hi Dana-

Try this:

$DatasetQuery->AddDBParam('language_correspondence', 'French', 'all');


I can't tell you why the cutoff is 50 - - someone mentioned it a few
weeks ago, though...
See if that 'all' helps.

Best of luck-

Alex P. Gates

-----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 2: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




_______________________________________________
FX.php_List mailing list
FX.php_List at mail.iviking.org
http://www.iviking.org/mailman/listinfo/fx.php_list



More information about the FX.php_List mailing list