shawnmos Posted March 17, 2003 Share Posted March 17, 2003 I converted a database created in Access to MySQL but I am having a problem. All of the data inside a field in a table is missing the ending quote and I am getting this message when trying to update the information.... ERROR: Unclosed quote @ 72 STR: \' SQL:`arcmessages` WHERE `iMessageID` = \'7\' AND `txMessage` = \'darn...I wanted to be first... Error SQL-query : `arcmessages` WHERE `iMessageID` = \'7\' AND `txMessage` = \'darn...I wanted to be first... MySQL said: You have an error in your SQL syntax near \'\'darn...I wanted to be first... \' at line 1 Is there anyway to go through and add the ending quote to all the rows in the field? Quote Link to comment Share on other sites More sharing options...
effigy Posted March 17, 2003 Share Posted March 17, 2003 where do you want the quote added? e.g. -- has the access file been saved as a delimited ascii file to import? Quote Link to comment Share on other sites More sharing options...
shawnmos Posted March 17, 2003 Author Share Posted March 17, 2003 it is already running live on my host\'s server. I didn\'t notice this problem until now. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.