Last but least is it possible to cast a select directly to a ClassRecord? IE
PostRecord post = create.select.from(POST).fetchOne() On 7 January 2013 16:53, Lukas Eder <[email protected]> wrote: > Hello Stuart, > >> I actually found the issue as some players may not have equipment, I had >> to do join left. > > > I see > >> >> Sorry for the String I was actually printing out the query with getSQL() >> and didn't update it! I have another small query how do you get the >> increment id when inserting? > > > As your ID columns are already AUTO_INCREMENT columns, your MySQL database > will do that for you. You can explicitly fetch the auto-generated ID using > jOOQ's INSERT .. RETURNING syntax, as documented here: > http://www.jooq.org/doc/2.6/manual/sql-building/sql-statements/insert-statement/#N10B37 > > There had also been a Stack Overflow question on that subject, recently > http://stackoverflow.com/q/8127378/521799 > > Cheers > Lukas
