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

[Jonathan Schwartz]

Bob,

Oh…I thought that you actually saw the Parse Error.

I would start substituting to troubleshoot.

Here are some ideas:
	- Same query, create new layout.
	- Change to FindAll
	- Same query, limit to one record (Could be a content issue).

Hope that helps.

Jonathan Schwartz
jonathan at exit445.com



On Apr 24, 2015, at 4:03 PM, Bob Patin <bob at patin.com> wrote:

> 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> 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> wrote:
>>>> 
>>>> Webcompanionport isn’t a variable?
>>>> 
>>>> J
>>>> 
>>>> Jonathan Schwartz
>>>> jonathan at exit445.com
>>>> 
>>>> 
>>>> 
>>>> On Apr 24, 2015, at 2:59 PM, Bob Patin <bob at patin.com> wrote:
>>>> 
>>>>> What can be wrong with this?
>>>>> 
>>>>> Here’s my server data page:
>>>>> 
>>>>> <?php
>>>>> $serverIP = “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
>>>>> 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
>>>>> 
>>>>> 
>>>>> _______________________________________________
>>>>> 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
>> _______________________________________________
>> 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