What does your update statement look like. ? Are you specifying and Insert or
an update ? What are you using to update
the tables , is it a entity bean ?
Santosh
Panos Konstantinidis <[EMAIL PROTECTED]> on 12/22/2000 04:28:26 AM
Please respond to A mailing list about Java Server Pages specification and
reference <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc: (bcc: Santosh Daryani/IT/Aon Consulting)
Subject: Database is freaking out!!!!
Hello there. I have written a jsp file that opens a connection with a
database on the local network. This database has a table (lets say users)
that has two fields (lets say created and last_cist)of type timestamp(14). I
have a login and a registration form for the user. The first time the user
registers I get the current date and write it in the "created" field. From
then, everytime the user loggs in I update the "last_vist" field. Now every
time I update the "last_visit" field the "created" field is beeing updated
automatically!!!!!!!!!!! (and it is always almost five minutes before the
"last_visit" field (lets say "created" is 20001222091839 and "last_visit" is
20001222092315). The database I am using is mySQL. Is it a bug with the
mySQL or is there something else I never thought about. Please help, it is
really annoying.
Thanks.
Panos
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
