[FX.php List] RE: Form not seeing database (XPOST)
VanBuskirk, Patricia
pvanbuskirk at fsu.edu
Sat Jun 23 11:36:11 MDT 2012
I took out all the dropdown php info and tried to submit the form without it. Got this error back:
Catchable fatal error: Object of class FX_Error could not be converted to string in E:\Inetpub\wwwroot\Forms\Repair\repairconfirm.php on line 106
~ Trish
From: fx.php_list-bounces at mail.iviking.org [mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of VanBuskirk, Patricia
Sent: Saturday, June 23, 2012 1:10 PM
To: FX.php Discussion List
Subject: [FX.php List] Form not seeing database (XPOST)
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/33b90d75/attachment.html
More information about the FX.php_List
mailing list