I was entering some information in the Manual Data area for a computer, and got an error when using an apostrophe (IE: Mr. Smith's computer). I got around it by using \' instead of a ' by itself.
here's the error:
[code] Fatal Error:
UPDATE `system_man` SET `system_man_value` = '', `system_man_description` = 'Mr. Smith's Vista Notebook', `system_man_location` = 'Mr. Smith's House', `system_man_serial_number` = '', `system_man_date_of_purchase` = '2007-03-01' WHERE `system_man_uuid` = '4C4C4533-0052-4B10-8050-B4A04F4D4331'
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 's Vista Notebook', `system_man_location` = ''Mr. Smith's House', `system_man_ser' at line 1
Array ( [pc] => 4C4C4533-0052-4B10-8050-B4A04F4D4331 [category] => manual [view] => summary [system_man_location] => 'Mr. Smith's House [system_man_date_of_purchase] => 2007-03-01 [system_man_value] => [system_man_serial_number] => [system_man_description] => 'Mr. Smith's Vista Notebook [save] => Save ) [/code]
|