[FX.php List] Drop-down stopped working

[VanBuskirk, Patricia]

Hi Bob,  It is trying to not pull a value list, it should be listing down all the values in the "ListForWeb" field.  I checked and the database name and layout are correct and there are records in it as well.  It was working before the switch, but now it just shows a bunch of blank lines, a capital "F", and a bunch more blank lines.  Errrrrrgh.

~ Trish

From: fx.php_list-bounces at mail.iviking.org [mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Bob Patin
Sent: Thursday, December 29, 2011 3:56 PM
To: FX.php Discussion List
Subject: Re: [FX.php List] Drop-down stopped working

Hi,

Don't change the version? It needs to stay "FMPro7".

Do you have the value list on the layout "Ref_FSU_Buildings?" If not, that's your problem; the value list you're accessing has to be on the layout you're going to.

If it *is* on that layout, does it have any values? Does that table have any records? It needs at least one in order to get to the value list.

Hope that helps,

Bob Patin
Longterm Solutions LLC
bob at longtermsolutions.com<mailto:bob at longtermsolutions.com>
615-333-6858
http://www.longtermsolutions.com
FileMaker 9, 10 & 11 Certified Developer
Member of FileMaker Business Alliance and FileMaker TechNet
--
Twitter: bobpatin
Google+: http://www.longtermsolutions.com/plus
AIM: longterm1954
iChat: bobpatin
--
Expert FileMaker Consulting
FileMaker Hosting for all versions of FileMaker

On Dec 29, 2011, at 2:39 PM, VanBuskirk, Patricia wrote:


We are setting up a new FM server and a new Web server.  Now my dropdown that reads from the FM database stopped working.  I've changed the server_data.php file to point to the proper database.  I even tested it by typing the information directly into the form, instead of having it user that file and it still didn't work.

Here's the text I'm using:

<select name="Contact_Bldg" tabindex="5">
  <option selected>NOT LISTED - Type in Below</option>
  <?php
define('DEBUG', true);

require_once('FX.php');
require_once('server_data.php');

// configure a connection to FileMaker Server Advanced
$ordersQuery = new FX(FM_IP, FM_PORT, FM_VERSION);
// set database and layout information
$ordersQuery->SetDBData('WEB_Forms', 'Ref_FSU_Buildings', 'all');
// set database username and password
$ordersQuery->SetDBUserPass(FM_USERNAME, FM_PASSWORD);
// retrieve all records in this database available to the current user
$ordersQuery->AddSortParam('ListForWeb', 'ascend');
$orders = $ordersQuery->DoFXAction(FX_ACTION_FINDALL);
        foreach ($orders as $contact) {
    echo "                <option>{$contact['ListForWeb']}\n";

}
?>
</select>

The only thing I can think of is that the new server is now FMS11, so maybe I need to change the version in the server_data.php file?  It presently says, "FMPro7".

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