krash_io — Mon, 28 Jan 2002 05:44:31 +0000

Hey that worked great, but I needed to add a DESC to the end of that to get the news date, thanks for your help!

Krash_io

Mark Hensler — Mon, 28 Jan 2002 04:01:01 +0000

It should work with the same query that MS SQL Server uses.

SELECT TOP 1 * FROM table_name ORDER BY field_name

krash_io — Mon, 28 Jan 2002 03:26:06 +0000

Unfortunately I'm using Access

-Krash

Mark Hensler — Sun, 27 Jan 2002 22:36:09 +0000

What kind of server are you using? (mySQL, M$ SQL, MS Access, etc.) There are some differences among these servers... the LIMIT query being one of them.

mySQL is what Will & I posted.
mySQL Docs: 6.4.1 SELECT Syntax

M$ SQL would look like this:
SELECT TOP 1 * FROM table_name ORDER BY field_name

M$ SQL Docs: SELECT

Wil — Sun, 27 Jan 2002 15:31:16 +0000

Try this:

SELECT * FROM table_name ORDER BY field_name DESC LIMIT 0,1

krash_io — Sun, 27 Jan 2002 07:07:48 +0000

That seems to give me an error on LIMIT.

Any suggestions?

Mark Hensler — Sun, 27 Jan 2002 06:29:16 +0000

SELECT * FROM table_name ORDER BY field_name DESC LIMIT 1

Where field_name is your Timestamp/DateTime/Date data type field.