need help with cfquery

[mkauspe]

This should be an easy one ... unfortunately I am a n00b to sql and CF. I am
trying to display a certain column in a table, the most recent one. I have a
column row setup as an int value giving a new number on each submission. I want
to display the highest number, but no that value itself. Basically I have a
table with id and articletext, I want to display the articletext column that
has the highest id number. Hope that makes sense. I know the attached code is
completely wrong but I cannot figure out what function I need to use.

I am trying to create a way that users can log in, create an article, and post
it on the site, like a blog but not as advanced. This is my first big web
programming db driven project. Thanks a lot for any help!



<cfquery name="article" datasource="anti_sql">
SELECT id, articletext, artcldate
FROM articles
HAVING id
WHERE id=MAX(id)
</cfquery>

[paross1]

One way...

<cfquery name="article" datasource="anti_sql">
SELECT id, articletext, artcldate
FROM articles
WHERE id=(SELECT MAX(id) FROM articles)
</cfquery>

Phil

[mkauspe]

You're my new hero! Worked like a charm, I feel an inch less like a n00b lol

[mkauspe]

Now I want to display the articles previous to that. Is there any easy way to
create a sql statement that displays the previous ID numbers. I know I can do
this:

SELECT id, articletext, artcldate, artclauthor, artclname
FROM articles
ORDER BY id DESC

But that creates a jumbled mess like so: [url]http://mindaugas.us/show.cfm[/url]

I would like to be able to dsiplay one article at a time. So I need something
like this?

SELECT id, articletext, artcldate, artclauthor, artclname
FROM articles
WHERE id=(SELECT LAST(id) FROM articles)

but sql 2k doesn't have last I think, plus that would select the last one, I
need the second to most recent.

Sorry for the total n00b questions this is the first time I have done anything
with db's. I am trying to get a head start in school and for my own benefit. I
really appreciate any help. Links to good sql tutorials are good also ;)