I'm running an application that is connected to a MySQL database. I have a Servlet with a method that connects to the database and attempts to update a table named INSTRUCTORS. I keep a properties file full of SQL statements, one of which is:
updateInstructorQuery=UPDATE INSTRUCTORS SET ADMINISTRATOR_ID=?, RETIRED_ADMIN_ID=NULL, EMPLOYEE_ID=?, FIRSTNAME=?, LASTNAME=?, DEPARTMENT=?, WORK_PHONE=?, ADDRESS=?, CITY=?, STATE_PROVINCE=?, COUNTRY=?, ZIP_PCODE=?, HOME_PH0NE=?, CELL=? WHERE COMPANY_ID=? AND EMPLOYEE_ID=?;
SQL Problem: Column not found message from server: "Unknown column 'HOME_PH0NE' in 'field list'" SQL State: S0022 Vendor Error: 1054 20 [http-8080-Processor24] ERROR mvcs.InstructorModel - SQL Exception java.sql.SQLException: Column not found message from server: "Unknown column 'HOME_PH0NE' in 'field list'"
I don't understand why I'm getting this exception when the HOME_PHONE field is definitely a field in the table INSTRUCTORS! I'm thinking there must be something wrong with my SQL statement, but I don't see it!