Select Max not working here

[J. Muenchbourg]

I'm trying to pull the highest 'articleid' value out of an sql table,
but the below is giving me an Incorrect syntax near 'articleid' error:


dim sqlid
sqlid = "SELECT max articleid from tblarticles"
Set rsid = Server.CreateObject("ADODB.Recordset")
rsid.Open sqlid,sqlc,3


????
Muench

 

[Ray at]

Try:

select max(articleid) from tblarticle

<optional>
Then do

iHighID = sqlc.Execute(sqlid)(0).value
</optiona>

Ray at work

 

[Aaron Bertrand - MVP]

How about

SELECT MAX(articleid) FROM tblArticles

 

[WIlliam Morris]

You're almost right.

SELECT max(articleid) from tblarticles {note the parentheses}