[FX.php List] OK, this is driving me crazy...

[Bob Patin]

Unfortunately, not that… that was just a copy error when I was writing the email...

I just can’t find it.

Here’s the code straight from the page:

<?php

include_once('FX/FX.php');
include_once('FX/server_data.php');

$comp = "bac";

$q = new FX ($serverIP,'80',$dataType,$scheme);
$q->SetDBData($dbname,'web_catalog');
$q->SetDBPassword($webpw,$webun);
$q->AddDBParam('composer',$comp);
$qResult = $q->FMFind();

echo $qResult['foundCount'];
?>

It never finishes, which indicates a parse error, but I can’t for the life of me find it.

What’s interesting is that an FMView works fine on the previous page, so I know that it’s connecting properly to the database and that WPE is working…

I wasted over an hour on it… headed to the couch… :)

Bob Patin
Longterm Solutions
bob at longtermsolutions.com
615-333-6858
FileMaker 9, 10, 11, 12 & 13 Certified Developer
http://www.longtermsolutions.com
-
iChat: bobpatin at me.com
Twitter: bobpatin
—
FileMaker Consulting 
FileMaker Hosting for all versions of FileMaker
PHP • Full email services • Free DNS hosting • Colocation • Consulting


> On Apr 24, 2015, at 5:29 PM, James Dcunha <jdcunha at supportgroup.com> wrote:
> 
> You missing the $ symbol for webCompanionPort variable in the FX object instantiation step. 
> 
> James
> 
> Sent from my Phone
> 
> On Apr 24, 2015, at 6:14 PM, Bob Patin <bob at patin.com <mailto:bob at patin.com>> wrote:
> 
>> well, i could set it to 80 manually; seems like i had that issue once before… will try it.
>> 
>> … and…
>> 
>> … no joy.
>> 
>> 
>>> On Apr 24, 2015, at 5:02 PM, Jonathan Schwartz <jonathan at exit445.com <mailto:jonathan at exit445.com>> wrote:
>>> 
>>> Webcompanionport isn’t a variable?
>>> 
>>> J
>>> 
>>> Jonathan Schwartz
>>> jonathan at exit445.com <mailto:jonathan at exit445.com>
>>> 
>>> 
>>> 
>>> On Apr 24, 2015, at 2:59 PM, Bob Patin <bob at patin.com <mailto:bob at patin.com>> wrote:
>>> 
>>>> What can be wrong with this?
>>>> 
>>>> Here’s my server data page:
>>>> 
>>>> <?php
>>>> $serverIP = “fms5.longtermsolutions.com <http://fms5.longtermsolutions.com/>";
>>>> $webCompanionPort = "80";
>>>> $scheme = 'http';
>>>> $dataType = 'FMPro7';
>>>> $dbname = ’thedatabase.fp7';
>>>> $webun = ‘yada';
>>>> $webpw = ‘more-yada';
>>>> ?>
>>>> 
>>>> and here’s my query; I can’t for the life of me figure out why this never finishes when I try to load it…
>>>> 
>>>> <?php
>>>> include_once('FX/FX.php');
>>>> include_once('FX/server_data.php');
>>>> 
>>>> $composer =‘bach’;
>>>> 
>>>> $q = new FX ($serverIP,webCompanionPort,$dataType,$scheme);
>>>> $q->SetDBData($dbname,'web_catalog',50);
>>>> $q->SetDBPassword($webpw,$webun);
>>>> $q->AddDBParam('composer',$composer);
>>>> $qResult = $q->FMFind();
>>>> echo $qResult['errorCode’];
>>>> ?>
>>>> 
>>>> I’ve echoed back all of the variables, and they’re legit; this is a silly little FIND and yet I can’t make it work.
>>>> 
>>>> Could it be something to do with FMS 11?
>>>> 
>>>> This should return 206 records, but instead, the page never loads, which indicates a parse error… and I just don’t see it…
>>>> 
>>>> The version of FX that I’m running is v6.0.
>>>> 
>>>> Thanks for any help,
>>>> 
>>>> Bob Patin
>>>> Longterm Solutions
>>>> bob at longtermsolutions.com <mailto:bob at longtermsolutions.com>
>>>> 615-333-6858
>>>> FileMaker 9, 10, 11, 12 & 13 Certified Developer
>>>> http://www.longtermsolutions.com <http://www.longtermsolutions.com/>
>>>> -
>>>> iChat: bobpatin at me.com <mailto:bobpatin at me.com>
>>>> Twitter: bobpatin
>>>> —
>>>> FileMaker Consulting 
>>>> FileMaker Hosting for all versions of FileMaker
>>>> PHP • Full email services • Free DNS hosting • Colocation • Consulting
>>>> 
>>>> 
>>>> _______________________________________________
>>>> 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 <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 <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 <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

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