It looks like you're missing a comma in your SQL statement in between placeOfBirth and civilStatus.
Good Luck! Dennis ----- Original Message ----- From: "Mylin Campos" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 23, 2002 2:13 AM Subject: sql problem > > Hi all, > > I just wanted to know if you guys can help me out with this error. It's > actually an sql and jdbc error. > > I have a class called employeeDBUtil. In this class, it has a method called > updateEmployee. I wanted to try if the code would work so I created a main > portion in my class. > > java.sql.SQLException: Syntax error or access violation: You have an error > in your SQL syntax near 'eMName='Fabio', bDay = '03-14-63', > placeOfBirth='manila' civilStatus= 'married' at line 1 > at org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java:497) > at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(MysqlIO.java:550) > at org.gjt.mm.mysql.MysqlIO.sqlQuery(MysqlIO.java:635) > at org.gjt.mm.mysql.Connection.execSQL(Connection.java:882) > at org.gjt.mm.mysql.Connection.execSQL(Connection.java:815) > at org.gjt.mm.mysql.Statement.executeUpdate(Statement.java:227) > at org.gjt.mm.mysql.jdbc2.Statement.executeUpdateStatement.java:97) > at > com.ccp.hrmdpayroll.employee.EmployeeDBUtil.updateEmployee(EmployeeDBUtil.ja va:161) > at com.ccp.hrmdpayroll.employee.EmployeeDBUtil.main(EmployeeDBUtil.java:731) > > Would anyone know how to solve this? > > lyn > > > > _________________________________________________________________ > Get faster connections -- switch to MSN Internet Access! > http://resourcecenter.msn.com/access/plans/default.asp > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
