[FX.php List] $useInnerArray

[Dale Bengston]

It returns a one-fewer-dimensional array. It depends on where you  
start measuring dimensions, I guess. :-)

Dale

On Apr 6, 2007, at 12:18 PM, Vision Computer Consulting wrote:

> Thank you. I will try to read the documentation more throughly next  
> time.
>
> You explanation was helful though.
>
> I interpret to mean that you get a 2 dimensional array returned  
> instead of a 3 dimensional array. Is that correct?
>
> Stephen
>
> On Apr 6, 2007, at 10:01 AM, Dale Bengston wrote:
>
>> No, it has nothing to do with simulating SQL syntax. From the  
>> FXFunctions.pdf (page 10):
>>
>> >> The final parameter, $useInnerArray, determines whether the  
>> returned data should make
>> allowance for repeating fields and/or portals.  This is discussed  
>> in greater detail in connection with
>> the FlattenInnerArray() function, above.
>>
>> The discussion of FlattenInnerArray() is also on page 10:
>>
>> By default, FX.php adds an inner layer to the returned array to  
>> allow for FileMaker repeating fields
>> and/or portals.  Since most fields on a layout usually do not fall  
>> into these criteria, often code to
>> display field data will have a trailing "[0]".  FlattenInnerArray 
>> () can be used to remove this inner layer
>> if desired, and so obviate the need for the trailing, bracketed  
>> zero.  This function has no associated
>> parameters.
>>
>>
>> So, what it really means is without FlattenInnerArray() or  
>> $useInnerArray, your reference to a field's contents on a specific  
>> record would be:
>>
>> $returnData['data'][key]['myField'][0]
>>
>> ...and with FlattenInnerArray() or $useInnerArray, it would be:
>>
>> $returnData['data'][key]['myField']
>>
>>
>>
>> Dale
>>
>>
>>
>> On Apr 6, 2007, at 11:53 AM, Vision Computer Consulting wrote:
>>
>>> Is $useInnerArray similar to doing a SQL 'INNER JOIN'? If so, how  
>>> would you do an 'LEFT OUTER JOIN'?
>>>
>>> _______________________________________________
>>> 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