Error: Default property not found for object 1

[Ciarrai]

I am using forms, etc in ASP and so need to know what the next number is available for use. I know the sql works, but for some reason I can't get it to print to the page.
I keep getting the following error: ASP 0185 (0x8002000E)Default property not found for object.


<% Set Conn = Server.CreateObject(&quot;ADODB.Connection&quot%>

<!--#include file=../includes/dbann.asp-->

<%dim NextID
NextNum=&quot;select Max(ACS_ROLE_ID)+1 from jjwwp.ACS_ROLE&quot;

set NextID = conn.Execute(NextNum)



response.write (NextID)
%>

 

[Tarwn]

The error is on the NextID object. The NextID object is a recordset object. There is no default method for this object. The easiest way to print out the contents would be to name your field your pulling back and print it out like this:

NextNum="select Max(ACS_ROLE_ID)+1 as MaxRoleId from jjwwp.ACS_ROLE"
set NextID = conn.Execute(NextNum)
response.write (NextID("MaxRoleId"))

This tells the recordset to look at the current record it is queued to and send back the value of the field MaxRoleId. You could also not bother putting the AS in your sql statement and simply refer to the field by number:

NextNum="select Max(ACS_ROLE_ID)+1 from jjwwp.ACS_ROLE"
set NextID = conn.Execute(NextNum)
response.write (NextID(0))

This is shorthand (using defaults) for NextId.fields(0).value

w3schools.com has an excellent refernce for all of the ADO objects here:

http://www.w3schools.com/ado/default.asp

-Tarwn



_{01010100 01101001 01100101 01110010 01101110 01101111 01101011 00101110 01100011 01101111 01101101}
^{29 3K 10 3D 3L 3J 3K 10 32 35 10 3E 39 33 35 10 3K 3F 10 38 31 3M 35 10 36 3I 35 35 10 3K 39 3D 35 10 1Q 19}
Do you know how hot your computer is running at home? I do

http://www.tiernok.com/hscripts/systemp.asp