[thelist] ASP: Select only the first record

[Kristof Neirynck]

> "SELECT * FROM news ORDER BY date DESC LIMIT 1"

That's for MySql.

when you're working with an access database it is

"SELECT TOP 1 * FROM news ORDER BY date DESC"


Kristof