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

[Bob Patin]

Good idea about the layout. I tried FindAll and it didn't work either... which is what is so odd.

Another thing: the same layout is used on a form where I'm pulling a half-dozen value lists...

Also, I could do a search by one field but not another--both text fields, both indexed, both straight-ahead text fields with nothing exotic...

I even tried recovering the file just to see if that was it; I tried re-indexing the field I was testing with...

Argh...


> On Apr 24, 2015, at 6:30 PM, Jonathan Schwartz <jonathan at exit445.com> wrote:
> 
> 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
> 
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list