[FX.php List] Nagging FX problem

[Bob Patin]

it gets me a TON of stuff, which is probably the problem; I didn't write the database, and she has a HUGE # of long value lists.

I went at it a different way, since the value list I need consists of all the 9 members of a specific table; just did a FINDALL and used that instead...

I suspect her value lists in total are just too much data; just the first one displayed appears to be thousands of names... and she has maybe 40 value lists in there.


Bob Patin
Longterm Solutions
bob at longtermsolutions.com
615-333-6858
http://www.longtermsolutions.com
iChat: bobpatin
FileMaker 9, 10 & 11 Certified Developer
Member of FileMaker Business Alliance and FileMaker TechNet
--
Expert FileMaker Consulting 
FileMaker Hosting for all versions of FileMaker
PHP • Full email services • Free DNS hosting • Colocation • Consulting:

On Apr 6, 2011, at 10:59 AM, Steve Winter wrote:

> Chucking ideas up...
> 
> What does;
> 
> echo '<pre>';
> print_r($vlResult['valueLists']);
> print_r($vlResult['valueLists']['Team']);
> echo '</pre>\;
> 
> Give you...?
> 
>> OK, I've done value-list-based pulldowns a thousand times... this time it refuses to work:
>> 
>> I have the value list on a field on my web layout;
>> 
>> I have a list called "Team"; it has a half-dozen values;
>> 
>> In my page I have this:
>> 
>> AT THE TOP:
>> $vl = new FX($serverIP,$webCompanionPort);
>> $vl->SetDBData('bps_Service.fp7','web');
>> $vl->SetDBPassword($wpw,$un);
>> $vlResult = $vl->FMView();
>> 
>> I echoed an errorCode for the above, and got 0; interestingly, a foundcount returns -1... maybe that's normal for value lists, I don't know.
>> 
>> 
>> IN THE BODY OF THE PAGE:
>> <select name="technician" class="bodytext">
>>  <?php 
>> foreach($vlResult['valueLists']['Team'] as $key=>$value) {
>> ?>
>> <option value="<?php echo $value; ?>"><?php echo $value; ?></option>
>> <?php
>>     	} 
>> ?>
>>   </select>
>> 
>> I've probably done this 50 times, never had any trouble; this is using FMS 10... other data on the page loads just fine, from the same web layout.
>> 
>> Help appreciated... my day is getting away from me!
>> 
>> Thanks,
>> 
>> 
>> Bob Patin
>> Longterm Solutions
>> bob at longtermsolutions.com
>> 615-333-6858
>> http://www.longtermsolutions.com
>> iChat: bobpatin
>> FileMaker 9, 10 & 11 Certified Developer
>> Member of FileMaker Business Alliance and FileMaker TechNet
>> --
>> Expert FileMaker Consulting 
>> FileMaker Hosting for all versions of FileMaker
>> PHP • Full email services • Free DNS hosting • Colocation • Consulting:
>> 
>> _______________________________________________
>> FX.php_List mailing list
>> FX.php_List at mail.iviking.org
>> http://www.iviking.org/mailman/listinfo/fx.php_list
> 
> Steve Winter
> steve at bluecrocodile.co.nz
> m: +44 77 7852 4776
> 3 Calshot Court, Channel Way
> Ocean Village, Southampton SO14 3GR
> 
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.iviking.org/pipermail/fx.php_list/attachments/20110406/a6fceb1c/attachment-0001.html