Menu

#41 Using an apostrophe causes db error

open
nobody
Fields (9)
5
2006-05-15
2006-05-15
David Lynum
No

(anyInventory 2.0)When including an apostrophe in a
name, such as Joe's computer, I get the following error:

DB Error: syntax error

You can assist in the development of anyInventory by
submitting this error as a bug report.

UPDATE `anyInventory_items` SET `name`='David's
Computer' WHERE `id`='117'

If I remove the apostrophe then the name is accepted.

David

Discussion


Log in to post a comment.

MongoDB Logo MongoDB