[FX.php List] Nagging FX problem

Bob Patin bob at patin.com
Wed Apr 6 10:10:12 MDT 2011


Thanks, it's from another table in the same file... 

You may be right that it's choking on some special (or hidden) characters in one of her value lists... as I mentioned, I did away with the value list and just went at the 9 records... thankfully that's all this page requires.

BP


On Apr 6, 2011, at 11:06 AM, Jonathan Stark wrote:

> A couple thoughts:
> 
> 1) If the data for that value list is coming from a different file, it
> could be that the permissions are not set up to allow web access.
> 2) If the values list is based on a relationship, there might be a
> context disconnect. For example, a global value that needs to be set
> prior to related values appearing.
> 3) Are there any special characters in the value list items that FM or
> FX might be choking on?
> 4) Check for typos (trailing spaces in the vl name perhaps?)
> 
> Best,
> j
> 
> --
> Mobile Strategy, Design, & Development
> http://jonathanstark.com
> 
> Buy my iPhone book:
> http://amzn.com/0596805780
> 
> Buy my Android book:
> http://amzn.com/1449383262
> 
> 
> 
> 
> On Wed, Apr 6, 2011 at 11:59 AM, Steve Winter <steve at bluecrocodile.co.nz> 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
>> 
>> 
> _______________________________________________
> 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