If a single quote is in a new circulation name, the SQL Insert fails.
- New Circulation
- Type into "Circulation Name" field: John Smith's Computer
- Click button: Complete
Error message is:
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 Computer', '4', 0, '3', 0, 0)' at line 1- INSERT INTO cf_circulationform values (null, '1', 'John Smith's Computer', '4', 0, '3', 0, 0)
- in the text fields, replace all single quotes (') with two single quotes ('') to have the SQL statement passed properly to the database.
Log in to post a comment.