[FX.php List] Drop-down stopped working

[Bob Patin]

Oh… not sure where I got the idea it was a value list.

Did you try returning the error?

echo $ordersQuery['errorCode'];

That'll tell you why it's not returning anything; 401 means no records found; in the FX folder you should have a file called "FM Errors" (I think that's it) and it'll tell you what each of the error codes mean. Also, since they're the same as what fileMaker uses, you can find the list in the Help docs that are in FileMaker.


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 3:06 PM, VanBuskirk, Patricia wrote:

> Hi Bob,  It is trying to not pull a value list, it should be listing down all the values in the “ListForWeb” field.  I checked and the database name and layout are correct and there are records in it as well.  It was working before the switch, but now it just shows a bunch of blank lines, a capital “F”, and a bunch more blank lines.  Errrrrrgh.
>  
> ~ Trish
>  
> From: fx.php_list-bounces at mail.iviking.org [mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Bob Patin
> Sent: Thursday, December 29, 2011 3:56 PM
> To: FX.php Discussion List
> Subject: Re: [FX.php List] Drop-down stopped working
>  
> 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”.
>  
> _______________________________________________
> 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/20111229/e785577e/attachment.html