Better to use a DB-specific construct if possible (TOP for Acces/SQL
Server, LIMIT for MySQL, etc.), unless database independance is
important.  At least in my opinion.

cheers,
barneyb

On Thu, 12 Aug 2004 12:03:36 -0400, Joe Rinehart <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Why not just select the latest customer record in one shot?
>
> <cfquery maxrows="1">
>  SELECT ...columns...
>  FROM customers
>  ORDER BY creationDate DESC
> </cfquery>
>
> -joe
--
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to