ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Emiliano Armellin <earmel...@ateikon.com>
Subject Abator select by example with the Java2 or Java5 Generator Set
Date Wed, 09 May 2007 09:53:44 GMT
Hello,

how can I create a select like this with the example class (java 2 or 
java 5 generator set)?
|
select *
from table
where field1 <> ?
and (field2 is not null or field3 is not null or field4 is not null)|

I'm unable to group the 3 *or* clause under 1 *and *clause, is it possible?


thanks for the help


-- 
Emiliano Armellin

    *
      W_
      www.ateikon.com <http://www.ateikon.com>
    *
      @_
      earmellin@ateikon.com <mailto:earmellin@ateikon.com>
    *
      T_
      *+39 0422 452101*

Get Firefox! <http://www.spreadfirefox.com/?q=affiliates&id=15653&t=86>
Get Thunderbird <http://www.mozilla.org/products/thunderbird/>

Mime
View raw message