db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "subramaniam ilango" <silang...@hotmail.com>
Subject "IS NULL AS" in select clause not working
Date Mon, 21 Mar 2005 12:06:56 GMT
Hi,
      I have a query
given below "select  REG_DATE, REG_DATE IS NULL AS isnull from
USER order by isnull ASC, REG_DATE ASC;"

which I prefer doing it in Torque. I had been trying some thing like
given in the code snippet below which doesn't seem to work.
Can any one help  me to get this query in torque..

      Criteria criteria = new Criteria(7)
        .addSelectColumn(UserPeer.REG_DATE)
        .addAsColumn("asNull", UserPeer.REG_DATE+" IS NULL" )
        criteria.addAscendingOrderByColumn("asNull");
        criteria.addAscendingOrderByColumn(UserPeer.REG_DATE);


Thanks
Ilango

_________________________________________________________________
Make money with Zero Investment. 
http://adfarm.mediaplex.com/ad/ck/4686-26272-10936-31?ck=RegSell Start your 
business.


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message