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

[Michael Layne]

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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: text/enriched
Size: 3270 bytes
Desc: not available
Url : http://www.iviking.org/pipermail/fx.php_list/attachments/20050419/0fcbd64d/attachment.bin