sorry saini but i dont see any different from your answer thank you 2009/12/8 Sushim Saini <sushimsa...@gmail.com>
> hi Nguyen Xuan Son > use > pstmtname.executeQuery() instead of pstmtname.executeQuery(); > > On Tue, Dec 8, 2009 at 11:29, Nguyen Xuan Son <yama...@gmail.com> wrote: > > > dear all > > I've written > > Connection conn = null; > > PreparedStatement pstmtname = null; > > pstmtname = conn.prepareStatement(sql); > > sql = "UPDATE tbl_content_admin_accounts SET CA_PASSWORD = ? WHERE > ROW_ID > > = > > " + UserID; > > pstmtname.setString(1, "123456"); > > pstmtname.executeQuery(); > > > > there is no error appear but nothing is changed in the database > > do you have any suggestion? > > thank you very much > > > > -- > > ======================================================================= > > Ritsumeikan University, Asia JinZai Project > > Master of Information Science > > Nguyen Xuan Son > > > > Add : Japan, Shiga-Ken, Kusatsu-Shi, Kasayama 3choume 1-18 > > ShiteiHaimu > > Rien, Room 103 > > Tel/Fax : 81-(0)90-3976 2246 > > Email : nr000...@ed.ritsumei.ac.jp > > Mobile : 81-(0)90-3976 2246 URL : http://www.ritsumei.jp > > ======================================================================= > > > > > > -- > -- > Sushim Saini > -- ======================================================================= Ritsumeikan University, Asia JinZai Project Master of Information Science Nguyen Xuan Son Add : Japan, Shiga-Ken, Kusatsu-Shi, Kasayama 3choume 1-18 ShiteiHaimu Rien, Room 103 Tel/Fax : 81-(0)90-3976 2246 Email : nr000...@ed.ritsumei.ac.jp Mobile : 81-(0)90-3976 2246 URL : http://www.ritsumei.jp =======================================================================