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

[Nick Trenary]

Hmm...I'm a bit perplexed here.  Neither of your suggestions worked but
$query->AddDBParam ('ProgramID', $_GET['id'], 'gte'); or
$query->AddDBParam ('ProgramID', $_GET['id'], 'lte');  
works.  None of the other operators work. 

I am truly baffled.

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
>
> -----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