Hi, I am working on a VS time clock project to be used for student's to clock in and out. When the student clocks in the time/date is saved to a temp table. Upon login out to the login screen for the next user to use I need to save the clocked in time to a permanate table. It is an update from the temp table to the permanate table. However, when the page redirects to the login page, I recieve the dbnull to date is invalid error. Now understand, when the page is redirecting to the login page for the next user, the only way I could figure out to get the browser to forget the sessionstate, was to use a delete statement that removes the data from the perm table, but before it erases it, I need to save it to the permanate database table.
Anyone have a solution they can send my way??
View Complete Post