I suspect you mean the blank string " " passed to the concat function? Yes, that's a documentation flaw. Thanks for reporting this. This will be fixed as #2332 https://github.com/jOOQ/jOOQ/issues/2332
Cheers Lukas 2013/3/13 <[email protected]> > Hi all, > > I am new to jOOQ and try to go through the user manual. I couldn't run the > following code in #4.5.2 Alias > Columns<http://www.jooq.org/doc/3.0/manual-single-page/#aliased-columns>. > I find an email from Lukas > Eder<https://groups.google.com/d/msg/jooq-user/qIJlk4JPZCc/7P02gapjLTQJ> and > figure out that I should convert String to org.jooq.Field using > org.jooq.impl.Factory.val. I suppose it is a document issue. Right? Thanks > in advance. > > > Code from jOOQ User Manual (it doesn't work): > > Record record = create.select( > concat(AUTHOR.FIRST_NAME, " ", AUTHOR.LAST_NAME).as("author"), > count().as("books")) > .from(AUTHOR) > .join(BOOK).on(AUTHOR.ID.equal(BOOK.AUTHOR_ID)) > .groupBy(AUTHOR.FIRST_NAME, AUTHOR.LAST_NAME).fetchAny(); > > -- > 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. > > > -- 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.
