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.
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
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.
posted 8 years ago
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.