Modified the code.

On Monday, September 24, 2012 9:17:43 AM UTC+3, JK wrote:
>
>
> Thank you for your responses. Factory.trueCondition() was exactly what I 
> was looking for.
>
> How would you write following parametrized SQL with DSL API:
>
> select name from person where name :EQUALITY ':VALUE' order by name :ORDER
>
> :VALUE part is easy, but how to implement :EQUALITY and :ORDER without 
> writing any SQL?
>
> I was looking for something like this:
>
> equality = jOOQ.Equality.GT
> ordr = jOOQ.Order.ASC
>
>
> select().from(PERSON).where(PERSON.NAME.comparison(equality,value)).orderBy(PERSON.NAME.order(ordr))
>
> but it seems not to go this way.
>
>
>
>

Reply via email to