Quick and probably easy question for someone.

I am trying to setup a recordset in dreamweaver that selects the row with the most recent date. Hope that made sense - I have had some problem getting dreamweaver to do it.

I have used this as sql:

select *
From table
Where date=MAX(date_stored)

Anyway - it isn't working at all - seems really simple. I also tried using:
select top 1 *
From table
order by date DESC

this did not work because it didn't like the order by.

Any help is appreciated.

Chris

Your last query should work theoretically. However, date is a reserved word in some databases.

Either rename the column to something like DateAdded or whatever its purpose is or put the name in []:

SELECT TOP 1 * FROM table ORDER BY DateAdded DESC

or

SELECT TOP 1 * FROM table ORDER BY [date] DESC


HtH,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

DOH!

I was kicking myself last night over this.

I had named the field "date stored" originally - after trying a bunch of things last night I changed it to date_stored - but didn't retry my first sql statement. It works well now.

Thanks as always Imar,

Chris

You're welcome.

Out of curiosity, what ever happened to your survey? Did that work out as planned?

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: Radian by Air (Track 5 from the album: 10 000hz legend) What's This?

Hi Imar -

The survey is alive and kicking! It runs through July 8th - no gliches or lag as far as I know. Luckily - it has been more of a trickle of people than a flood - maybe a few hundred people a day versus 5000 at once. I really apreciate your help with everything (as I am sure many people her do!)

I am working on a new project for my wife now - a sample tracking system - (I am sure I will be posting a few more time with questions!)


Thanks again,

Chris