[FX.php List] records search limit?
Dale Bengston
dbengston at preservationstudio.com
Tue Oct 31 14:55:40 MST 2006
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
More information about the FX.php_List
mailing list