Data with apostrophe's causing database error
- Single Page
Posted 17 November 2011 - 12:46 PM
The reason this appears to happen is because the author has used single quotes to open tags, e.g.
<input type = 'text' value='something's happened' />
If you change these in the main library to use double quotes, as is the recommendation for xhtml, then it works, e.g.
<input type = "text" value="something's happened" />
Posted 19 November 2011 - 19:32 PM
If you have a varchar and try to save something with a single quote/apostrophe character in it, you'll get an SQL error.
The reason this appears to happen is because the author has used single quotes to open tags, e.g.
<input type = 'text' value='something's happened' />
If you change these in the main library to use double quotes, as is the recommendation for xhtml, then it works, e.g.
<input type = "text" value="something's happened" />
[/quote]
I think you're right. I will changed it to the next version.
Posted 12 March 2012 - 15:18 PM
Posted 12 March 2012 - 20:48 PM