[FX.php List] records search limit?

[Dana Benciu]

The table I am working with has 355 fields. The number of fields that I 
am trying to pull from the database is maybe 10, most of them either 
date or text fields, with less than 50 characters.

Dana.

P.S. I am testing now the SetDBData function ...

Gjermund Gusland Thorsen wrote:
> How much data in each field?
> How many fields?
>
> ggt667
>
> On 10/31/06, Dana Benciu <dbenciu at awid.org> wrote:
>> 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

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