[FX.php List] Get Last Record

Jonathan Schwartz jschwartz at exit445.com
Fri Dec 4 14:37:19 MST 2009


Excellent!

Thanks


>Off the top of my head, while sitting in a train station, what about 
>a find where -recid > 0 sorted by -recid descending, returning only 
>one record?
>
>Cheers
>Steve
>
>Sent from my iPhone
>
>On 4 Dec 2009, at 15:48, Jonathan Schwartz <jschwartz at exit445.com> wrote:
>
>>Hi Folks,
>>
>>OK. I admit to being lazy on this, posting my question rather than 
>>researching for 2 hours....how do you retrieve just the last record 
>>in a file in an efficient manner?
>>
>>I thought of the following:
>>    1) Do an initial query. Get last foreach. But that makes all 
>>records transfer.
>>    2) Do a single record query that contains a related record with 
>>reverse sort. Get from portal
>>
>>Isn't there a get last record parameter?
>>
>>Thanks
>>
>>Jonathan
>>
>>--
>>Jonathan Schwartz
>>Exit 445 Group
>>jonathan at exit445.com
>>http://www.exit445.com
>>415-370-5011
>>_______________________________________________
>>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


-- 
Jonathan Schwartz
Exit 445 Group
jonathan at exit445.com
http://www.exit445.com
415-370-5011


More information about the FX.php_List mailing list