[FX.php List] broken relationships in FM6/FX

[Michael Layne]

Thanks Gjermund.  Can you expand on that?  I do it all the time. It 
usually works...  It's not working on a particular machine.

What do you suggest?

Thanks!

Michael
On Apr 19, 2005, at 12:16 PM, Gjermund Gusland Thorsen wrote:

> This happens when you try to loop through an array using an instance 
> of FX.
>
> Gjermund
>
> On 4/19/05, Dale Bengston <dbengston at preservationstudio.com> wrote:
>> Hi Michael,
>>
>> This doesn't have anything to do with that pesky Web Security Database
>> does it?
>>
>> Dale
>>
>> On Apr 19, 2005, at 9:01 AM, Michael Layne wrote:
>>
>>> Another note:
>>>
>>> I've broken the page down to this...
>>>
>>> <?
>>> include ("../l/global.php");
>>> include ("../l/FX.php");
>>>
>>>       $db = "group";                          // FileMaker database
>>>       $lay = "web";                           // FileMaker layout
>>>
>>>       $query = new FX($ip, $port);
>>>       $query->SetDBData($db,$lay);
>>>       $query->AddDBParam('groupID',2003);
>>>
>>>       $r = $query->FMFind();
>>>       $d = current($r['data']);
>>> print_r($r);
>>> //echo $result['foundCount'];
>>> echo "<br /><b>::" . $d['groupID'][0] . "::</b><br />";
>>>
>>> foreach($r['data'] as $l) {
>>>       echo "loop: " . $l['groupID'][0] . "<br />";
>>> }
>>> ?>
>>>
>>> 3 machines return:
>>>
>>> Array (  [data] => Array  (  [3.0] => Array  (  [groupID] => Array  (
>>> [0] => 2003  )  )  )  [linkNext] => [linkPrevious] => [foundCount] =>
>>> 1  [fields] => Array  (  [0] => Array  (  [emptyok] => YES
>>> [maxrepeat] => 1  [name] => groupID  [type] => NUMBER  [extra] => )  
>>> )
>>>  [URL] =>
>>> http://127.0.0.1:591/FMPro?-db=group&-lay=web&-format=-fmp_xml&-
>>> max=50&groupID=2003&-find  [query] => [errorCode] => 0  [valueLists]
>>> => Array  (  )  )
>>> ::2003::
>>> loop: 2003
>>>
>>> the other:
>>>
>>> Array (  [data] => Array  (  [3.0] => Array  (  [groupID] => Array  (
>>> [0] => 2003  )  )  )  [linkNext] => [linkPrevious] => [foundCount] =>
>>> 1  [fields] => Array  (  [0] => Array  (  [emptyok] => YES
>>> [maxrepeat] => 1  [name] => groupID  [type] => NUMBER  [extra] => )  
>>> )
>>>  [URL] =>
>>> http://127.0.0.1:591/FMPro?-db=group&-lay=web&-format=-fmp_xml&-
>>> max=50&groupID=2003&-find  [query] => [errorCode] => 0  [valueLists]
>>> => Array  (  )  )
>>> ::2003::
>>>
>>> Notice: Undefined index: groupID in
>>> /Library/WebServer/Documents/awards123/remax/products.php on line 14
>>>  loop:
>>>
>>>
>>> Thanks if anyone has an idea!
>>>
>>> Michael
>>>
>>>
>>>
>>>
>>>
>>> On Apr 19, 2005, at 9:34 AM, Michael Layne wrote:
>>>
>>>> I've run up against something pretty strange.  I have a FX.php
>>>> solution with FM6 that's working beautifully on 3 machines...  but
>>>> not the production server.  I'm getting errors that seem to point to
>>>> a relationship that FX doesn't like.  All machines are running
>>>> Panther, Apache, and PHP (4.3.4 - 4.3.10).
>>>>
>>>> It looks like it doesn't like a relationship -
>>>>
>>>> undefined index group::groupID...
>>>>
>>>> but I also see this everywhere...
>>>>
>>>> Invalid argument supplied for foreach() in
>>>> /Library/WebServer/Documents...
>>>>
>>>> I even created a new layout and placed 1 field on it... the query
>>>> returns:
>>>>
>>>> Undefined index: groupID...
>>>>
>>>> Any ldeas?  Thanks!!!!!!
>>>>
>>>>
>>>>
>>>>
>>>> Michael Layne  :  9 degrees development  :  www.9degrees.com  :
>>>> 404.226.7835 _______________________________________________
>>>> FX.php_List mailing list
>>>> FX.php_List at mail.iviking.org
>>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>>>
>>>
>>> Michael Layne  :  9 degrees development  :  www.9degrees.com  :
>>> 404.226.7835
>>> _______________________________________________
>>> 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
>

Michael Layne  :  9 degrees development  :  www.9degrees.com  :  
404.226.7835
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: text/enriched
Size: 4024 bytes
Desc: not available
Url : http://www.iviking.org/pipermail/fx.php_list/attachments/20050419/d5ed5374/attachment.bin