[FX.php List] Form not seeing database (XPOST)

VanBuskirk, Patricia pvanbuskirk at fsu.edu
Sat Jun 23 11:10:16 MDT 2012


I have had to re-setup our web server and FM server.   The databases are hosted and open, and have all the correct web settings and were previously working fine (just copied to a backup folder prior to the maintenance work and copied back when completed).

The forms contain dropdown lists that pull in from the database(s) that will not work now.  Does anyone have an idea for why this stopped working?

Here's an example of the code in the form.  The form stops at that point ... doesn't show the dropdown info, and also doesn't show any more of the form.  I tried replacing the line that requires the server_data.php file with the actual lines from that file, but that didn't work either.

<?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('Dept_Directory', 'SG_SectionsLIST', 'all');
//$ordersQuery->SetDBData('WEB_Forms', 'SG_Sections', '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);
    echo "                <option>Student Request\n";
            foreach ($orders as $contact) {
    echo "                <option>{$contact['ListForWeb']}\n";

}
?>


Trish Van Buskirk
Technology Specialist
Information Technology Services
Florida State University
2035 E. Paul Dirac Dr / Tallahassee, FL 32310
Phone: (850) 645-8063
http://www.its.fsu.edu

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


More information about the FX.php_List mailing list