SFSDBManager.executeUpdate() bugged

[ericheimburg]

I think I've found a pretty serious bug in executeUpdate... the version that takes parameters doesn't process the parameters at all.

Code: Select all

String tempName = "temp-" + tempID++;
db.executeUpdate("INSERT INTO account SET username=?, password='', email=''", new Object[]{tempName});

This causes an error:

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

It's like it isn't turning the ? into the symbols at all.

executeQuery() does work... this is specifically executeUpdate.

[Lapo]

It is a known bug, already in top priority for the next update.
Thanks