I have a problem.
I was using a prepared statement before, and tried switch over to use this
Code: Select all
String sql = "SELECT * FROM users WHERE username=?";
ISFSArray result = db.executeQuery(sql, new Object[]{name});
This now gives me the following error:
Code: Select all
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 '?' at line 1
It worked fine with prepared statements, and now fails. I'm using MySQL.
I'll go back to getConnection and preparing statements I guess.