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

[Michael Layne]

I don't believe so.  good suggestion.  They're not running on any of  
the machines...

Thanks.

On Apr 19, 2005, at 11:56 AM, Dale Bengston 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
>

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: 4089 bytes
Desc: not available
Url : http://www.iviking.org/pipermail/fx.php_list/attachments/20050419/b0c0bbc9/attachment-0001.bin