[FX.php List] records search limit?

[Dale Bengston]

I think the 50 record limitation comes from FMSA, not from FX. It was  
present in CDML too. Or was that 25?

Dale

On Oct 31, 2006, at 3:55 PM, Dale Bengston wrote:

> I think the cutoff is 50 to prevent us from accidentally spraying  
> thousands of records around unless we specifically put in 'all' as  
> the 3rd parameter.
>
> Incidentally, it goes in SetDBData(), not AddDBParam(). Dana didn't  
> post the top part of his query.
>
> Dale
>
> On Oct 31, 2006, at 2:38 PM, Alex Gates wrote:
>
>> 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
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list