[FX.php List] $_GET not working in links after upgrade from FM5.5 to 9

[Andrew Denman]

I'm really shooting in the dark now...

An oldie but goody: is the FileMaker Server IP correct? It is obviously
connecting to A FileMaker server to give you the 401 error, but is it
connecting to the same FileMaker server your computer is?

Is curl enabled on your Mac server?  If you do a phpinfo(); there should be
a curl section.  I seem to remember a discussion about curl on Macs before,
but I don't remember the default setting for a Mac install, other than it
can be different because PHP has to be compiled with the correct options.  I
don't know if curl is the issue here, but it is a possible difference
between the two computers.  If curl not being installed happens to be the
problem I'm sure one of the Mac users on this list could provide more info.

Andrew Denman

-----Original Message-----
From: fx.php_list-bounces at mail.iviking.org
[mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Nick Trenary
Sent: Tuesday, December 11, 2007 2:06 PM
To: FX.php Discussion List
Subject: Re: [FX.php List] $_GET not working in links after upgrade from
FM5.5 to 9

Ok, a bit more here.

My web server is sitting on my dmz, running OS X 10.3.9, Apache 1.3, php 
v4.4.4.  It appears for some reason I can't search for a specific record 
similar to what's suggested below.  But if I use the exact same test 
environment on the test web server on my computer my searches work.  My 
computer, running XP, Apache 1.3, php v.4.4.1,  is on the same network 
as my Filemaker server.  What the hell?

Nick

Andrew Denman wrote:
> That is odd.  Is there any white space (extra returns, spaces) in the
> ProgramID field in FileMaker that could be causing the search to not
match?
> Try explicitly stating the search type:
>
> $query->AddDBParam ('ProgramID', $_GET['id'], 'cn'); - if those numbers
are
> in the ProgramID field this search should return it, but you won't want to
> use this search type on your live application.
>
> $query->AddDBParam ('ProgramID', $_GET['id'], 'eq'); - if the above search
> works and this one doesn't there are probably extra characters in the
field.
>
> Andrew Denman