hai friends....
Actualy am doing intranet application in
jsp,servlets...in that attendance page,login,logout time is calculated on click....the database has the following colums staff_id,staff_name,date,staff_login,staff_logout,etc....the case is...
morning if a person login,their id,name,login time has to be taken to database...
similarly if a person logout their id,name,login,logout time has to be entered....but id,name,login time will be already enterd in a row....during logout time insert query cant be used as it get inserted in second row...so retrieval will be a problem.......
session concept is not used...........
get me a proper suggestion......regarding querry