No worries, it happens to the best :) Cheers, Lukas
2016-04-12 18:37 GMT+02:00 <[email protected]>: > Yep you called it. I had my parentheses incorrect. I deleted and started > from scratch and got it to work as expected. Sorry about that. > Thanks again. > > On Tuesday, April 12, 2016 at 10:56:14 AM UTC-5, Lukas Eder wrote: >> >> Hi James, >> >> Thank you very much for your enquiry. That would be surprising indeed, >> but I cannot seem to reproduce it. For instance, the following: >> >> System.out.println( >> DSL.or( >> field("A").eq(1).and(field("B").eq(2)), >> field("C").eq(3).and(field("D").eq(4)) >> ) >> ); >> >> Yields: >> >> ( >> ( >> A = 1 >> and B = 2 >> ) >> or ( >> C = 3 >> and D = 4 >> ) >> ) >> >> >> Are you sure your simplified query (which doesn't compile, btw, as you're >> missing arguments to the eq() methods) does reflect the actual query where >> you experienced this? >> >> Note that there is also a where(Condition...) overload, which connects >> conditions with AND at the top level. In case you got the parentheses wrong. >> >> Lukas >> >> 2016-04-12 16:19 GMT+02:00 <[email protected]>: >> >>> I'm trying to create a complex WHERE condition using the jOOQ DSL and >>> it's not working as expected. I'm using version 3.7.2. >>> Here is the SQL I'm trying to output: >>> >>> WHERE ((field1 = ? AND field2 = ?) OR (field3 = ? AND field4 = ?)) >>> >>> I'm trying to use the jOOQ DSL like the following: >>> >>> .where(DSL.or(FIELD1.eq().and(FIELD2.eq()), FIELD3.eq().and(FIELD4.eq >>> ()))) >>> >>> This outputs an `AND` between the two conditions. Is this a correct use >>> of `DSL.or`? Is there another means of accomplishing what I would like to >>> do? >>> >>> Thanks, >>> James Lorenzen >>> >>> -- >>> 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. > -- 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.
