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

[Ness, David]

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<mailto: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> [mailto:fx.php_list-bounces at mail.iviking.org<mailto: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<mailto: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<mailto: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<mailto:FX.php_List at mail.iviking.org>
http://www.iviking.org/mailman/listinfo/fx.php_list

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.iviking.org/pipermail/fx.php_list/attachments/20130521/7e6da603/attachment-0001.html