Hi ;
I am usein the following prepared statement: insertOne = dbConnection.prepareStatement( "INSERT INTO appointment (apptId,providerId,patientId,serviceLocationId, dateTime, assistant, duration,state,statechange,memo,cancelMemo,dictationMarked, apptSeqId, clinicId, appSharing) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)" ); If there is a "'" in any of the data field that is defined as char i am getting the following errors: ERROR EXCEPTION: [java.sql.SQLException: Syntax error or access violation: and in the field memo data looks like this: 'PT'S MOTHER COMPLAINED AND REQUESTED THROAT' The versin of the MYSQL i use is 3.22.32 . Operating System is AIX 4.3.3. Thanks for your help Hamid Amjadi 626-449-1705 --------------------------------------------------------------------- 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
