[FX.php List] Drop-down stopped working

[VanBuskirk, Patricia]

WoooHooo ... Got it working!  ... but still perplexed.  Before switching servers, it worked fine as is.  Which is this:  I created relationships to 2 other databases (ReferenceTables and Dept_Directory) and placed layouts on my Orders database for those dbs/tables.  It was to these layouts that the forms looked for the drop-down info.

In troubleshooting, I changed the forms to look to the actual database for the list, and now they work.

Huh?!

~ Trish


-----Original Message-----
From: fx.php_list-bounces at mail.iviking.org [mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Chris Hansen
Sent: Thursday, December 29, 2011 5:30 PM
To: FX.php Discussion List
Subject: Re: [FX.php List] Drop-down stopped working

Trish,

I opened the resulting file from the URL that Webko posted using BBEdit and there's definitely something odd going on.  Though generally not human-readable, at the top is the phrase "This program cannot be run in DOS mode", so this is apparently a Windows executable, and not merely an arbitrary extension.  Something to do with how the server is configured to handle XML perhaps?  Is this a fresh server (fresh OS install, etc.) or merely a repurposed box?

--Chris

On Dec 29, 2011, at 3:21 PM, VanBuskirk, Patricia wrote:

> It's been a while since I've messed with the php settings ... we used to have a techie that did all the software/OS side of the servers.  Can you remind me where to look to see if it's running.  It's not listed in the servers on there, so I'm guessing not there.
>  
> ~ 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 5:16 PM
> To: FX.php Discussion List
> Subject: Re: [FX.php List] Drop-down stopped working
>  
> Is PHP actually running? On my web servers, if PHP isn't active, it'll cause the page to be downloaded. This doesn't sound the same, but actually more sinister--what EXE is it downloading?
>  
> Just one more example of why I avoid Windows web servers...
>  
> It doesn't sound like FileMaker is even getting the query...
>  
>  
> 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 4:10 PM, Tim 'Webko' Booth wrote:
> 
> 
> Dear All,
> 
> Did you put that errorCode line in there? What is it telling you?
> 
> That's where you need to start... otherwise you could search forever and 
> it turns out to be a simple error...
> 
> What's the errorCode?
>  
> Trish sent me the files back channel - there's something funky going on. I'm getting the "Mismatched tag at line X" error - which is usually something in high ASCII stuffing up the XML. So I grabbed the base query URL and ran it directly:
>  
> http://web:web@146.201.5.152:80/fmi/xml/FMPXMLRESULT.xml?-db=WEB_Forms
> &-lay=Ref_FSU_Buildings&-max=all&-findany
> Which then causes a download of an .exe file (so not a wonder FX.php is not liking the data format). I've never seen this happen before, so I suspect it's a Server thing...
> Other people's thoughts?
> Cheers
> Webko
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>  
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list

_______________________________________________
FX.php_List mailing list
FX.php_List at mail.iviking.org
http://www.iviking.org/mailman/listinfo/fx.php_list