[FX.php List] Current function

Bob Patin bob at patin.com
Thu Nov 13 12:05:53 MST 2008


Hey G,

How do I use that? Do I put that line after a FOREACH?

I tried doing this:

foreach($queryResult['data'] as $key=$queryData);
list( $recid, $modid ) = explode( '.', $key );
echo $recid;

and I get nothing...

Thanks,

Bob


On Nov 13, 2008, at 12:13 PM, Gjermund Gusland Thorsen wrote:

> list( $recid, $modid ) = explode( '.', $key );
>
> ggt667
>
> 2008/11/13 Bob Patin <bob at patin.com>:
>> 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
>>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list



More information about the FX.php_List mailing list