do you have a line id or a timestamp on the table if so:
SELECT TOP 5 myCol,myTimestampCol FROM myTable ORDER BY myDateCol DESC > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > Sent: 30 September 2003 10:28 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] Latest Additions > > > > er.... > > I decided to do sometjing else on the system rather than the latest > additions part but obviuosly sent a blank email ... DOH! > The message footer is courtesy of Birmingham City Council not me ..... > > However since now I'm typing this anyway I need a way of > seeing the last > five additions to a table. Anyone got any bright ideas or can > point me at > some nice code that I can use.... > > Regards - Paul > > > > > ************************************************************** > *********************************** > The information contained within this e-mail (and any > attachment) sent by Birmingham City Council is confidential > and may be legally privileged. It is intended only for the > named recipient or entity to whom it is addressed. If you are > not the intended recipient please accept our apologies and > notify the sender immediately, or telephone +(44) 121 303 > 6666. Unauthorised access, use, disclosure, storage or > copying is not permitted and may be unlawful. Any e-mail > including its content may be monitored and used by Birmingham > City Council for reasons of security and for monitoring > internal compliance with the office policy on staff use. > E-mail blocking software may also be used. Any views or > opinions presented are solely those of the originator and do > not necessarily represent those of Birmingham City Council. > We cannot guarantee that this message or any attachment is > virus free or has not been intercepted and amended. > > ************************************************************** > *********************************** > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
