You are viewing a plain text version of this content. The canonical link for it is here.
Posted to torque-dev@db.apache.org by Shekhar <sh...@nowmediatech.com> on 2005/04/30 02:14:31 UTC
Help me
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
RE: Help me
Posted by Thomas Fischer <fi...@seitenbau.net>.
Please send questions regarding the usage of torque to the users list.
There are more people around which can help you with your problems than on
the dev list, you will get quicker answers.
Thanks a lot,
Thomas
P.S. look at the bottom of the peers howto, there is a code sample of how
to use the and and or methods.
"Shekhar" <sh...@nowmediatech.com> schrieb am 30.04.2005 02:14:31:
> 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
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org