"IS NULL AS" in select clause not working

Mon, 21 Mar 2005 04:07:00 -0800 

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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to