• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

SQL question

G

gear02

Member
I have this error where if I try to enter a ' into a search box in this program, I get the following error:

java.sql.SQLException: ORA-00911: invalid character

So I'm assuming that the ' is causing it. Are ' not permitted or do you need an escape character?

 
I'm not familiar with that environment (java, apparantly), but yeah, at least in PHP and MySQL, you need to escape single quotes with a backslash, ie \'. That's a bug, the program you're using should escape the characters if necessary.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top