Hello All, I have the following environment:
MySQL 4.1.3-beta-standard Connector/J 3.0.14 SUN Java JDK 1.4.2 SUSE Linux 9.1 I have written a java program to insert information into an "emp" table as follows: INSERT INTO dirxml.emp (fld_ind_id,fld_frname,fld_srname,fld_init,fld_sh_name1,fld_sh_name2,fld_posnacty_cd,fld_posnacty_name1,fld_posnacty_name2,fld_emp_job_desc1,fld_emp_job_desc2,fld_statrsn_cd,fld_statrsn_name1,fld_statrsn_name2,fld_rsn_cd,fld_aflgrp_cd,fld_aflgrp_name1,fld_aflgrp_name2,fld_city_t_name1,fld_city_t_name2,fld_manager_indv_id,fld_comm_lang) VALUES("100000087","SANIA","RANCOURT","","Miss","Mlle","TFR","T L VISION FRAN AISE R GIONALE","T L VISION FRAN AISE R GIONALE","MAKE-UP ARTIST","MAQUILLEUR (EUSE)","R01","RETURN TO ACTIVE STATUS","REMISE EN ACTIVIT ","019","U2R","STARF","STARF","QUEBEC","QUEBEC","SYSM63","F"); When I run this statement from MySQL Control Center, it work without any errors but when I execute it via java code, I get the following error: -- SEVERE: SQLException: Syntax error or access violation, message from server: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"QUEB' at line 1" -- SEVERE: SQLState: 42000 -- SEVERE: VendorError: 1064 Can someone please help what I may be doing wrong... Thanks, Shaffin. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]