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

[Dale Bengston]

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