[FX.php List] Drop-down stopped working

[Bob Patin]

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
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/b8d1a146/attachment.html