Jump to content


Photo

MySQL database


  • Please log in to reply
2 replies to this topic

#1 shawnmos

shawnmos
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 17 March 2003 - 01:20 AM

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?

#2 effigy

effigy
  • Staff Alumni
  • Advanced Member
  • 3,600 posts
  • LocationIL

Posted 17 March 2003 - 01:33 AM

where do you want the quote added? e.g. -- has the access file been saved as a delimited ascii file to import?
Regexp | Unicode Article | Letter Database
/\A(e)?((1)?ff(?:(?:ig)?y)?|f(?:ig)?)\z/

#3 shawnmos

shawnmos
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 17 March 2003 - 02:00 AM

it is already running live on my host\'s server. I didn\'t notice this problem until now.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users