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

[Andrew Denman]

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

-----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 11:14 AM
To: FX.php Discussion List
Subject: Re: [FX.php List] $_GET not working in links after upgrade from
FM5.5 to 9



Andrew Denman wrote:
> Nick,
>
> It looks like the ProgramID was passed (it is right before the '&-find' in
> the URL):
> [URL] =>
>
http://web:webuser@192.168.10.3:80/fmi/xml/FMPXMLRESULT.xml?-db=Events.fp7&-
> lay=web&-max=50&ProgramID=2529&-find
>
> Now for some questions...
> -Is 2529 the correct ProgramID for that record?
>   
Yes.
> -Why are you using strtok() on the ProgramID when you pull it from the
> database?  If you have a period in your ProgramID then that function is
> cutting it short.  
>   
I don't recall, I made these pages a few years ago.  I tested removing 
this code, same results.
> -Is the field 'ProgramID' the same case as it is defined in FileMaker?
>   
Yes.
> -Are you looking at the correct layout for the records you want to find?
>
>   
Yes. 
> Other than those possible issues I don't see in that code why it wouldn't
> work.
>
> 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 9:59 AM
> To: FX.php Discussion List
> Subject: [FX.php List] $_GET not working in links after upgrade from FM5.5
> to 9
>
> I am working on upgrading from FM5.5 to 9 and I am finding a few quirks 
> with my existing code.  I have several web pages where a user would see 
> a list of records, they could click on a link for that record and see 
> specific information about that record.  After the migration my _$GETs 
> don't seem to be working.
>
> In page one which lists the records I create a variable for a ProgramID 
> field like this:
> $recID = strtok($value['ProgramID'][0], '.');
>
> and then used $recID in my link:
> echo "<td class=\"$style2\"><a href=\"moreinfo2.php?id=$recID\">More 
> info</a></td>\n";
>
> In my 'More info' page this is my initial code:
> $query = new FX ($serverIP, $webCompanionport, $DataType);
> $query->SetDBPassword ($dbPassword, $dbUser);
> $query->SetDBData ('Events.fp7', 'web');
> $query->AddDBParam ('ProgramID', $_GET['id']);
> $result = $query->FMFind();
>
> print_r($result); shows
>
> Array
> (
>     [data] => Array
>         (
>         )
>
>     [linkNext] => 
>     [linkPrevious] => 
>     [foundCount] => 0
>     [fields] => Array
>         (
>         )
>
>     [URL] =>
>
http://web:webuser@192.168.10.3:80/fmi/xml/FMPXMLRESULT.xml?-db=Events.fp7&-
> lay=web&-max=50&ProgramID=2529&-find
>     [query] => 
>     [errorCode] => 401
>     [valueLists] => Array
>         (
>         )
>
> )
>
> It doesn't appear to be passing the value at all.  This code worked in
5.5.
>
>   

-- 
--

Nick Trenary
Computer Information Systems Analyst
Cedar Rapids Public Library
Office: 319.398.5145 x267
Cell: 319.310.7699


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