Can't get number returned using MAX function

[sysr]

I am developing an ASP page that is connected to an ACCESS database. I need to get a maximum value for a number field, add 1 to it and use that number as a key value to start the next record.

10 Set Con = Server.CreateObject("ADODB.Connection&quot
20 Con.Open "accessDSN"

30 sqlInteger="SELECT MAX(OrgID) AS [id] FROM Region"
40 Con.Execute sqlInteger

50 Response.Write(id)
60 id=id+1
70 Response.Write(id)

I can manipulate the database without any problems, so my connection is OK. When I display id on line 50 I get no response, on line 70, I get 1.

There are 5 records in the database and the field is set to be a number. I need to see a number in line 50???

Any help would be greatly appreciated!

 

[link9]

Yea, because you're not assigning the return value to anything. [id] only exists in the context of the SQL Query, not the ASP page, unless you explicitly assign the resulting dataset to a recordset. Does that make sense? So try this:

Set Con = Server.CreateObject("ADODB.Connection&quot
Con.Open "accessDSN"

dim rs
set rs = server.CreateObject("ADODB.Recordset&quot
rs.ActiveConnection = Con

sqlInteger="SELECT MAX(OrgID) AS [id] FROM Region"
rs.open sqlInteger

dim id
id = rs("id&quot

response.write(id)
id = id + 1
response.write(id)


Paul Prewett