[FX.php List] Current function

[Anders Monsen]

I was hoping to avoid adding a field since the recid should already be  
included as part of the array FMP sends over; my line of thinking was  
that I wanted to avoid extra fields if possible.

Anders

On Nov 13, 2008, at 11:54 AM, Bob Patin wrote:

> Maybe I'm missing something here, but I find it much simpler to put  
> a calc field in my tables to retrieve the recid, and then I pull in  
> that field when I pull in other fields. It only takes a single line  
> of code, and the field in FM is simply recid=get(recordid).
>
> Bob Patin
> Longterm Solutions LLC
> bob at longtermsolutions.com
> 615-333-6858
> http://www.longtermsolutions.com
> iChat/AIM: bobpatin
> FileMaker 9 Certified Developer
> Member of FileMaker Business Alliance
> --------------------------
> FileMaker hosting and consulting for all versions of FileMaker
> PHP • Full email services • Free DNS hosting • Colocation • Consulting
>
> On Nov 13, 2008, at 11:26 AM, Anders Monsen wrote:
>
>> Revisiting this function, is it possible to get the FileMaker  
>> record ID via current( )? I use this to pull fields from a found  
>> set of one, and I need to send over the recid in a form.
>>
>> Until now I have been using something like this:
>>
>> foreach($createResult['data'] as $key=>$value) {
>> 	$recordDetails = explode('.',$key);
>> 	$currentRecord = $recordDetails[0];
>> }
>>
>> While I like the elegance of current( ), I am not sure how to  
>> isolate the recid piece, which would be very useful.
>>
>> Thanks,
>> Anders
>>
>> On Sep 22, 2008, at 9:26 PM, Andy Gaunt wrote:
>>
>>> You can also use the current function for a single record
>>>
>>> $value = current($queryResult['data']);
>>>
>>> Then you can just echo $value['field'][0];
>>>
>>> Also, don't forget that if you have NO related data you can tell  
>>> your query that and drop the [0] completely eg;
>>>
>>> $queryResult = FMFind (true, 'full',false);
>>> $value = current($queryResult['data']);
>>> echo $value['field'];
>>>
>>> Cheers
>>>
>>> Andy
>>>
>>>
>>> On Sep 22, 2008, at 7:15 PM, Bob Patin wrote:
>>>
>>>> Leo,
>>>>
>>>> I use it when I'm pulling data from a single record, like this:
>>>>
>>>> foreach($findResult['data'] as $key => $value);
>>>> $field1 = $value['field1'][0];
>>>> $field2 = $value['field2'][0];
>>>> $field3 = $value['field3'][0];
>>>>
>>>> ... and so on. There's no need for a looping structure since your  
>>>> foundset only has a single record. I use it all the time...
>>>>
>>>> Also, you can use that same method if you want to retrieve the  
>>>> last record in the foundset. Opposite to FileMaker, which always  
>>>> shows you the first record in a foundset after a FIND, this  
>>>> method returns the last record.
>>>>
>>>> So if you get 10 records returned, and use that method above,  
>>>> you'll retrieve the values in the last record of the foundset,  
>>>> based on the sort rules you may have used.
>>>>
>>>> Bob Patin
>>>> Longterm Solutions
>>>> bob at longtermsolutions.com
>>>> 615-333-6858
>>>> http://www.longtermsolutions.com
>>>> iChat: bobpatin
>>>> AIM: longterm1954
>>>> FileMaker 9 Certified Developer
>>>> Member of FileMaker Business Alliance and FileMaker TechNet
>>>> --------------------------
>>>> FileMaker hosting and consulting for all versions of FileMaker
>>>> PHP • Full email services • Free DNS hosting • Colocation •  
>>>> Consulting
>>>>
>>>>
>>>> On Sep 22, 2008, at 6:03 PM, Leo R. Lundgren wrote:
>>>>
>>>>>
>>>>> 23 sep 2008 kl. 00.56 skrev Bob Patin:
>>>>>
>>>>>> Jonathan,
>>>>>>
>>>>>> You can use this:
>>>>>>
>>>>>> foreach($findResult['data'] as $key => $value);
>>>>>>
>>>>>> Notice the semicolon...
>>>>>
>>>>> Bob; What is this syntax for? I've never seen it being used  
>>>>> before. The only thing I can think of it accomplishing is to set  
>>>>> $key and $value to the values of the very last item in the array?
>>>>>
>>>>> -|
>>>>>
>>>>> _______________________________________________
>>>>> 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
>>>
>>>
>>
>> _______________________________________________
>> 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
>
>