I think MySQLFactory has become MySQLDSL<http://www.jooq.org/javadoc/latest/org/jooq/util/mysql/MySQLDSL.html>due to refactoring between 2.5 and later releases.
On Tuesday, July 2, 2013 9:33:48 PM UTC+1, [email protected] wrote: > > I am trying to convert this: > "SELECT username,level,email FROM `employees` WHERE `username` = '" + > username + "' AND `password` = PASSWORD('" + password + "') LIMIT 1" > > into > JOOQSQL.getInstance().create().select(DSL.fieldByName("username"), > DSL.fieldByName("level"), > DSL.fieldByName("email")).from(DSL.tableByName("employees")).where(DSL.fieldByName("username").equal(username)).and(DSL.fieldByName("password").equal(password)).limit(1).fetchOne(); > > However the password is not encrypted with mysql function > > when i google i found information about using MySQLFactory.password but > that wasnt an option in the 3.1 api > > anyone have and clue how to fix this probleM? > -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
