Count is a keyword. it might not be accepted. Try something else. Did u execute this query directly
On Fri, Jun 12, 2009 at 7:44 AM, DelGurth <[email protected]> wrote: > To me that COUNT seems like an alias for the result of COUNT(CD) as in > SELECT COUNT(CD) AS COUNT > > But, what is the error? > > DelGurth > > On Fri, Jun 12, 2009 at 3:35 PM, Brandon Goodin<[email protected]> > wrote: > > I didn't look over it thoroughly but i noticed you appear to have a > > misplaced "COUNT": > > SELECT CG , COUNT(CD) COUNT, > > SUM ( > > TO_DATE(EDATE||' '|| etime ,'DD-MM-YYYY HH24:MI:SS' ) - > > TO_DATE(ADATE||' '|| atime ,'DD-MM-YYYY HH24:MI:SS' ) > > ) total_time > > Perhaps you should check you SQL. > > Brandon > > > > > > On Fri, Jun 12, 2009 at 12:44 AM, Jahan Zaib <[email protected]> > > wrote: > >> > >> i am trying to run this but problem occurs > >> i have a class > >> ---- > >> public class CompleteCallsReportBean implements Serializable{ > >> /** > >> * > >> */ > >> private static final long serialVersionUID = 2192836100387342196L; > >> /** > >> * > >> */ > >> private String cg; > >> private String COUNT; > >> private String totalTime; > >> public void setCG(String cg) { > >> this.cg = cg == null ? null : cg.trim(); > >> } > >> public void setCOUNT(String COUNT) { > >> this.COUNT = COUNT == null ? null : COUNT.trim(); > >> } > >> public void setTotalTime(String totalTime) { > >> this.totalTime = totalTime == null ? null : totalTime.trim(); > >> } > >> public String getCG() { > >> return cg; > >> } > >> public String getCOUNT() { > >> return COUNT ; > >> } > >> public String getTotalTime() { > >> return totalTime; > >> } > >> } > >> > >> -------- > >> And Sql Map related to that is > >> : > >> <resultMap id="CompleteCallsReportMap" > >> class="com.prevail.bean.CompleteCallsReportBean" > > >> <result column="total_time" property="totalTime" jdbcType="VARCHAR" > /> > >> <result column="COUNT" property="COUNT" jdbcType="VARCHAR" /> > >> <result column="CG" property="cg" jdbcType="VARCHAR" /> > >> </resultMap> > >> > >> <select id="get_complete_call_summary_by_date" parameterClass="String" > >> resultMap="CompleteCallsReportMap" > > >> SELECT CG , COUNT(CD) COUNT, > >> SUM ( > >> TO_DATE(EDATE||' '|| etime ,'DD-MM-YYYY HH24:MI:SS' ) - > >> TO_DATE(ADATE||' '|| atime ,'DD-MM-YYYY HH24:MI:SS' ) > >> ) total_time > >> FROM COMPLETE_CALLS > >> WHERE EDATE = #date:VARCHAR# HAVING > >> ( > >> TRUNC (SUM ( > >> TO_DATE(EDATE||' '|| etime > >> ,'DD-MM-YYYY HH24:MI:SS' ) - TO_DATE(ADATE||' '|| atime > ,'DD-MM-YYYY > >> HH24:MI:SS' ) > >> ) *24 > >> ) > >> BETWEEN 0 AND 9 > >> ) > >> GROUP BY > >> CG order by total_time desc > >> </select> > >> --------------------------- > >> But it did not fetch any data, where as simply query run fine > >> What i do ? > >> Kindly Help > >> -- > >> Regards, > >> Jahan Zaib > >> > > > > >
