Hello,
2013/7/8 Pay Liu <[email protected]> > Hi, > > I'm using jooq 3.1.0. to render SQL, the code is as below, > > when I use limit (offset, numberOfRow) or offest(), > > the output SQL have params mark "?", > > Is it normal behavior? > Yes, jOOQ tries to render bind values whenever possible. This is in favour of your database being able to cache cursors and avoid hard-parsing similar statements. SQLite probably doesn't do that, though... > I expect to get the sql is "select * from zmenu limit 1 offset 0" > You can resort to explicitly inlining your bind values using DSL.inline(): http://www.jooq.org/doc/3.1/manual/sql-building/bind-values/inlined-parameters I.e. .limit(inline(1)) .offset(inline(0)) Cheers Lukas -- 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.
