last generated slno

[preethi Ayyappan]

Hi,
I need to get the last generated serial numberfrom my sql database.I tried the following my sql query directly in database.it is working.but when i use this in my servlet program,it is showing error.

 
rs1=st.executeQuery("select MAX(slno) from inboundcrm.time where usr_name='"+ USER +"'");
if(rs1.next())
{
String usrlogintime=rs1.getString("usr_login_time");
        System.out.println(usrlogintime);
   

error:

column usr_login_time not found

my database is correct and i am having the field usr_login_time in table time.when i use some other query like

    
rs1=("select * from time where usr_name='"+ USER +"'");

I am able to print the time.I dont know why MAX(slno) is not working in my servlet code.

please help me to solve this.

Thanks.

[Campbell Ritchie]

You aren't selecting usr_login_time in your query.

I think this thread would sit better in the JDBC forum, so I shall move it there.

CR