sql problem

[Mylin Campos]

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.java: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