[FX.php List] OK, this is driving me crazy... SOLVED
Bob Patin
bob at patin.com
Sat Apr 25 07:07:46 MDT 2015
Created a new layout with one field on it… problem solved.
Too weird. The layout I was using was one I created yesterday—no graphics, just 100 fields or so with labels. I was planning to weed out all the unused fields after I confirmed connection… but never got there.
Too weird. Never seen that happen in 12 years using FX.php.
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 25, 2015, at 8:01 AM, Bob Patin <bob at patin.com> wrote:
>
> I already did that; as I mentioned, a previous page accesses value lists without any trouble—same layout, same database, same query structure except for the last line.
>
> What’s odder, I can search one field but not others...
>
> Makes no sense.
>
> 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
>
>> On Apr 24, 2015, at 11:16 PM, James Dcunha <jdcunha at supportgroup.com <mailto:jdcunha at supportgroup.com>> wrote:
>>
>> Try to do a basic XML query to check if custom web publishing is working.
>>
>> James
>>
>> Sent from my Phone
>>
>>> On Apr 24, 2015, at 7:47 PM, Bob Patin <bob at patin.com <mailto:bob at patin.com>> wrote:
>>>
>>> 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 <mailto: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 <mailto: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
>>>
>>> _______________________________________________
>>> 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
>
> _______________________________________________
> 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/20150425/d7f61b59/attachment-0001.html
More information about the FX.php_List
mailing list