Re: FN-FORUM sql for last entry of an access database

date posted 13th July 2001 15:58

last entry from a database table:

SELECT TOP 1 * FROM TABLENAME ORDER BY unique_id DESC

or if its already in a recordset object rs.MoveLast

uploading images:

use an upload component, although i have a .inc file that allows for a pure
ASP upload with resorting to a component, *however* when i got it, it was
free and now they charge so the legalities may be murky.
----- Original Message -----
From: Rob Garbutt
To: [EMAIL REMOVED]
Sent: Friday, July 13, 2001 3:26 PM
Subject: FN-FORUM sql for last entry of an access database


does any one know the
sql for last entry of an access database

thanks in advance

Robin Garbutt
Portfolio Art & Design Ltd
Tel - +44 (0) 1204 383822
Fax - +44 (0) 1204 383866
Mob - +44 (0) 7811 185490
e-mail - [EMAIL REMOVED]

For further information please visit us at :-
www.portfoliodesign.net

The contents of this e-mail are confidential to the ordinary user of the
e-mail address to which it was addressed and may also be privileged. If you
are not the addressee of this e-mail you may not copy, forward, disclose or
otherwise use it or any part of it in any form whatsoever. If you have
received this e-mail in error please e-mail the sender.