[FX.php List] Get Last Record

Steve Winter steve at bluecrocodile.co.nz
Fri Dec 4 09:08:13 MST 2009


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



More information about the FX.php_List mailing list