Hi, Are you sure you have posted the correct query? There's no FROM clause...
I'd be a bit surprised, if such a critical bug slipped through our integration tests :-) so I suspect we'll need a little more information to reproduce this issue... Cheers Lukas 2014-06-16 19:26 GMT+02:00 Deven Phillips <[email protected]>: > I'm fairly new to jOOQ, so please bear with me if I have missed > something... > > I generated the code using the Gradle plugin and jOOQ version 3.2.2. > > When I attempt to run a query: > > Record rec = create.select( > > CUSTOMER.NAME.as("name"), > > CUSTOMER.CODE.as("code"), > concat( > > val("/v3/customer/"), > > CUSTOMER.CODE, > > val("/vdc")).as("vdc")) > > .where(CUSTOMER.CODE.eq(code)) > > .fetchOne(); > > > When I try to retrieve values, the values are not correlated properly. > Example: > > rec.getValue("name"); // Contains 'null' > rec.getValue("code"); // Contains the 'name' value > rec.getValue("vdc"); // Contains the 'code' value > rec.getValue(0); // Contains 'null' > rec.getValue(1); // Contains the 'name' value > rec.getValue(2); // Contains the 'code' value > rec.getValue(3); // Throws an exception saying invalid field option > > Can anyone suggest where I might be going wrong? > > Thanks in advance!!! > > Deven > > -- > 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 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.
