[FX.php List] Debugging my move to FM v12

[Chris Hansen]

My bad there.  Those examples haven't been updated in a long time.

On May 21, 2013, at 1:46 PM, Ness, David wrote:

> I even see that one of the examples supplied with the latest version of FX.php (v6) includes this code snippet using ‘-recid’ for a record FIND:
>  
> -----------------
>  
> $BookQuery = new FX($serverIP, $webCompanionPort, $dataSourceType);             // This line creates an instance of the FX class
> $BookQuery->SetDBData($bookListFile, "Detail_View");                            // The '->' indicates that SetDBData is part of
>                                                                                 // the FX instance we just created.
> $BookQuery->SetDBUserPass ($webUN, $webPW);                                     // Set the user name and password for the desired access.
> $BookQuery->AddDBParam('-recid', $_GET['ID']);                                  // '-recid' is a reference to the unique ID that FileMaker
>                                                                                 // creates for each record.  You'll also note that PHP
>                                                                                 // recognizes the parameters passed from the last page ('ID').
> $query = $_GET['query'];
> $BookData = $BookQuery->FMFind();
>  
> -------------------
>  
>  
>  
>  
>  
> On May 21, 2013, at 11:38 AM, "Ness, David" <dness at bondedbuilders.com> wrote:
>  
> I can verify that using ‘-recid’ with FX v4.5.1 on a FMSA v11 worked when using FMFind(), and when connected to FMSA v12 it does not. This even though ‘-recid’ isn’t a field name, using it just like you would when performing a FMEdit() or a FMDelete().
>  
> Obviously, I can change all of my instances where I used ‘-recid’ when performing a FMFind(). I’m not certain why I started using that, but it’s always worked, so I never thought anything more about it, until FMS v12. I’m glad I was able to find the problem.
>  
> Can somebody confirm that I should change my $dataSourceType from ‘FMPro7’ to  'fmalt' for use with FMS v12? I hadn’t seen that mentioned before, but like I said, I’ve been off-list for some time.
>  
>  
>  
>  
> David Ness
> FileMaker & Web Applications Developer
>  
> Bonded Builders Warranty Group
> 800-749-0381 x3123
>  
>  
> From: fx.php_list-bounces at mail.iviking.org [mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Nick
> Sent: Tuesday, May 21, 2013 11:20 AM
> To: FX.php Discussion List
> Subject: Re: [FX.php List] Debugging my move to FM v12
>  
> I don't think you can do a find by -recid? but I've never done it, so maybe??
>  
> Make sure you are using the "fmalt" type instead of FMPro7 for v12.
>  
> 
> On Mon, May 20, 2013 at 12:16 PM, Ness, David <dness at bondedbuilders.com> wrote:
> Hi everyone! Looking forward to seeing everyone at DevCon this year. I've been off-list for a while, but still doing my fx.php thing.
> 
> I am late to the FM v12 party, but I'd like to make the transition before DevCon but I'm running into a problem that I can seem to figure out. I'm sorry if this has been covered in previous threads.
> 
> Everything here works great when using a FMSA v11, but when using v12, when I perform a FMFind, some values in the return array appear to be missing.
> 
> After much experimentation, I discovered that when I replace:
> 
> $applicationdata->AddDBParam('-recid', $_SESSION['application_recid'], "eq" );
> 
> with:
> 
> $applicationdata->AddDBParam('recordid', $_SESSION['application_recid'], "eq" );
> 
> Everything now appears to work.
> 
> 'recordid' is a field I added to my FileMaker table that simply is a calc field = Get ( RecordID )
> 
> >>> Q: Is there something about using '-recid' that has changed when using FMSA v12?
> 
> FX_VERSION = 4.5.1
> 
> Thanks!
> David Ness
> FileMaker & Web Applications Developer
> 
> _______________________________________________
> 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