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

[Dale Bengston]

Hi Trish,

Second error first - your code is expecting an array and it's getting a php error object: FX_Error. Do a print_r on the variable in line 106 that's supposed to be your fx data array. You should then get better feedback about what's happening.

First error second. If your popup menu is truncating in the middle and breaking the page, it may have an element that contains corrupt data or characters being interpreted as an HTML entity. Try viewing source on the page to see if thempage code continues past where it stops drawing on the screen. With luck, it'll show you exactly which value is causing the fail.

Hope that helped,
Dale


On Jun 23, 2012, at 7:36 PM, "VanBuskirk, Patricia" <pvanbuskirk at fsu.edu> wrote:

> 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
>  
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.iviking.org/pipermail/fx.php_list/attachments/20120623/6364fc37/attachment.html