Got it. It works tks Lukas. Il 22 nov 2016 14:20, "Lukas Eder" <[email protected]> ha scritto:
> Hi Denis, > > Whew, I'm glad this still works. This means that the SQL injection > protection is still functional :) > > DSL.inline() is for creating "inlined variables" (or constants), like > DSL.val(), which creates "ordinary bind variables". See: > http://www.jooq.org/doc/latest/manual/sql-building/ > bind-values/inlined-parameters > > What you're looking for is DSL.field(), which gives you access to the > plain SQL API at your own SQL injection risk. See: > http://www.jooq.org/doc/latest/manual/sql-building/plain-sql > > Hope this helps, > Lukas > > 2016-11-22 13:31 GMT+01:00 Denis Miorandi <[email protected]>: > >> Hi Lukas, >> >> I'm building a field to use in my select, but >> >> Field<String> padded=inline("SUBSTRING("+AGENCIES.ID.getName()+", >> PATINDEX('%[^0]%', "+AGENCIES.ID.getName()+"+'.'), >> LEN("+AGENCIES.ID.getName()+"))"); >> >> but the following has duplicated quote '' instead of ' >> >> 'SUBSTRING(ID, PATINDEX(''%[^0]%'', ID+''.''), LEN(ID))' >> >> any ideas how to achieve this? >> >> -- >> 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/d/optout. >> > > -- > You received this message because you are subscribed to a topic in the > Google Groups "jOOQ User Group" group. > To unsubscribe from this topic, visit https://groups.google.com/d/ > topic/jooq-user/YxK63hfFbFw/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- 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/d/optout.
