db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Shekhar" <shek...@nowmediatech.com>
Subject Help me
Date Sat, 30 Apr 2005 00:14:31 GMT
Dear sir,

i don't know where to submit my query ?????.

this is my sql query, if i execute the below query in sql prompt it is working successfully.
i'm  using MySQL database.

SELECT *
FROM `schedule` where (startdate>= '20050428100000') and (startdate <= '20050428155959'
) or (enddate>= '20050428100000') and (enddate <= '20050428155959' ) ;

i'm facing big problem with Torque OR criteria.  how do i implement the above sql query into
OR criteria pls send your sample code to me rshekhar2000@hotmail.com
advance thangs to you.
=======================================
public  boolean checkRangelist(String startdate,String enddate)
    boolean bresult= false;
Criteria cr1 = new Criteria();
      
      //schedule start date
      if(startdate.length()>0){
         cr1.or(ChannelSchedulePeer.STARTDATE,new StringBuffer("'"+startdate+"'"),Criteria.GREATER_EQUAL);
         Criteria.Criterion cre1 = cr1.getCriterion(ChannelSchedulePeer.STARTDATE);
         cre1.and(cr1.getNewCriterion(
                             cre1.getTable(),
                             cre1.getColumn(),
                             new StringBuffer("'"+enddate+"'"),
                             Criteria.LESS_EQUAL)
               );

      }
      //schedule end date
      if(enddate.length()>0){
  cr1.or(ChannelSchedulePeer.ENDDATE,new StringBuffer("'"+startdate+"'"),Criteria.GREATER_EQUAL);

        Criteria.Criterion cre2 = cr1.getCriterion(ChannelSchedulePeer.ENDDATE);
        cre2.and(cr1.getNewCriterion(
                             cre2.getTable(),
                             cre2.getColumn(),
                             new StringBuffer("'"+enddate+"'"),
                             Criteria.LESS_EQUAL)
               );
      }
     cr1.addAscendingOrderByColumn(ChannelSchedulePeer.STARTDATE);
    
     lst = ChannelSchedulePeer.doSelect(cr1);

    System.out.println(cr1.toString()); 

    if(lst.size()>0)
        bresult=true;
     
    }
    catch(Exception ex){
      sError="Error="+ex.getMessage();
      
    }
    
    return bresult;
  }
======================================
this is the error i get when i try to execute the code 
Current Query SQL (may not be complete or applicable): SELECT Channel_Schedule.SCHEDULE_ID,
Channel_Schedule.DESCRIPTION, Channel_Schedule.COURSEXLET_ID, Channel_Schedule.STARTDATE,
Channel_Schedule.ENDDATE FROM Channel_Schedule WHERE (Channel_Schedule.STARTDATE>='20050428100000'
AND Channel_Schedul
e.STARTDATE<='20050428155959') AND (Channel_Schedule.ENDDATE>='20050428100000' AND Channel_Schedule.ENDDATE<='20050428155959')
ORDER BY Channel_Schedule.STARTDATE ASC

every thing fine execpt AND    pls send your sample code as soon as you can....very urgent

thanks in advance
Shekhar



Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message