SFSDBManager.executeUpdate() bugged
Posted: 02 May 2011, 06:15
I think I've found a pretty serious bug in executeUpdate... the version that takes parameters doesn't process the parameters at all.
This causes an error:
executeQuery() does work... this is specifically executeUpdate.
Code: Select all
String tempName = "temp-" + tempID++;
db.executeUpdate("INSERT INTO account SET username=?, password='', email=''", new Object[]{tempName});
It's like it isn't turning the ? into the symbols at 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 '?, password='', email=''' at line 1
executeQuery() does work... this is specifically executeUpdate.