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

[Gjermund Gusland Thorsen]

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
> 
> 
>