[FX.php List] Current function
Gjermund Gusland Thorsen
ggt667 at gmail.com
Thu Nov 13 12:12:03 MST 2008
What happened to copy paste?
ggt
2008/11/13 Bob Patin <bob at patin.com>:
> Right, that's not the error... I was just typing fast.
>
> I have the code right in my PHP page; why is it not echoing a recordid?
>
>
> On Nov 13, 2008, at 1:08 PM, Gjermund Gusland Thorsen wrote:
>
>> Ehh $key=>$queryData not $key=$queryData
>>
>> ggt
>>
>> 2008/11/13 Bob Patin <bob at patin.com>:
>>>
>>> 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
>>>
>>> _______________________________________________
>>> 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