issue using '' in inline

[Denis Miorandi]

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?

[Lukas Eder]

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

--
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 jooq-user+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Denis Miorandi]

Got it. It works tks Lukas.

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 jooq-user+unsubscribe@googlegroups.com.