June 3rd, 2011, 07:19 AM
Join Date: Jun 2011
Time spent in forums: 9 m 56 sec
Reputation Power: 0
Originally Posted by kochark
i have a table that contain a column "uemail".
i m stuck with an update statment where user can update his/her email with an alternate email.
("update table set uemail = '"+ getEdt()+"' where email='"+rBean.getUemail()+"'")
here getEdt is the new object that will set new email and getUemail is the old email through which a user is logged in.
by using the above query i am getting a successful update page but when i check the database, it contain the old email value only. and not updating it to a new value.
i am sure thr is something wrong with my update query.
please anyone help me out with this.
You should exe commit after updating the data.