SQL MAX function

[boux123]

Hi,

I am trying creating a sql query to retrieve the lasted identity # inserted into the table. Here is my code:

"

pdrQuery = "SELECT MAX(pdrNumber) FROM tblPDR"

Set oRsSub2 = oConn.Execute(pdrQuery)

pdrNumber = oRsSub2("pdrNumber")

Response.Write pdrNumber

"

The error is:

Item cannot be found in the collection corresponding to the requested name or ordinal.


I am not too sure how to fix this problem. Please advise.

 

[gmmastros]

try....

pdrQuery = "SELECT MAX(pdrNumber) [!]As pdrNumber[/!] FROM tblPDR"

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[boux123]

it work! Thx!

 

[gmmastros]

Do you understand why it works? If you don't, do you want me to explain it?

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[monksnake]

Nah George, it work, that's all it need to do

<.