[FX.php List] Cannot get FX to connect to FMP

[Bob Patin/Longterm Solutions]

Patricia,

Did anyone edit the layouts that the FX forms are using?

If the value list's name has changed, or if it's not on the layout  
that FX is accessing, then it won't show.

Simple problems I know, but the value list thing has gotten me before...

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



On Jul 23, 2008, at 10:12 AM, VanBuskirk, Patricia wrote:

> I am having major problems all of a sudden.  Our online forms are in  
> php
> on a designated server (Win Server 2003), using FX.php.  They started
> acting up Friday (the form just stopped when it got to the dropdown
> list, we got them working .. then again last night, we got them  
> working,
> then again this morning and I cannot get them working again.  They now
> show the entire form, but will not show the drop-down list (which pull
> from a field in FMP) and when submitted will not go to the confirm.php
> page (the physical file shows in the directory, but goes to a page not
> found error). And it does not make a record in FMP.
>
> We ran the included FM tests and all the web publishing tests come  
> back
> ok.  I have a test page that prints out the php settings, then lists  
> all
> the hosted databases available to the web (<?php  
> print_r($databaseList);
> ?>).  That works.
>
> When it gets to the following point in the form, it will not show the
> list:
>
> <select name="Contact_Bldg" tabindex="5">
>  <option selected>NOT LISTED - Type in Below</option>
>  <?php
>
> 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>
>
> This makes me think it has something to do with FX.  I re-downloaded
> fx.php, made sure the includes folder is where it is supposed to be,
> re-verified the php.ini is pointing to that folder, made sure all the
> includes are in there ... I am out of ideas and about to pull my hair
> out!!  Anyone have any suggestions??
>
> Trish
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list