kenapa ada ini ?
" and dateAbsence between :dateAbsence " +
" and
:dateAbsence " +
coba diperhatikan baik-baik.
apa benar emang sengaja parameternya sama2 dateAbsence?
bukannya mulai tanggal berapa sampe tanggal berapa?
atau maksudnya yg dicek adalah dateAbsence dari parameter?
coba direnungkan baik-baik...
jangan lupa cermati tulisan sendiri.
2009/8/4 Yogie Kurniawan <yogiek...@yahoo.com>:
>
>
> kalo untuk tipe data date pake ini bro
>
> setParameter("dateAbsence",fromDate, TemporalType.DATE);
>
> --- On Tue, 8/4/09, onsir salman <onsirsal...@gmail.com> wrote:
>
> From: onsir salman <onsirsal...@gmail.com>
> Subject: Re: [JUG-Indonesia] HQL utk >= dan <=
> To: jug-indonesia@yahoogroups.com
> Date: Tuesday, August 4, 2009, 4:26 AM
>
>
>
> saya sdh pake between masih belm bisa pak.
> fromDate = 2009-08-01
> toDate = 2009-08-31
>
> String hql2 = "select count(employee) from Absence where employee=
> :employee " +
> " and dateAbsence between :dateAbsence " +
> " and
> :dateAbsence " +
> " and absenceType = :absenceType ";
>
> Query query = HibernateConnection .session. createQuery( hql)
> .setParameter("employee",employee)
> .setParameter("dateAbsence",fromDate)
> .setParameter("dateAbsence",toDate)
> .setParameter("absenceType",absenceType) ;
>
> tapi klw saya buat spt ini betul
>
> String hql2 = "select count(employee) from Absence where employee=
> :employee " +
> " and dateAbsence
> between '2009-08-01' " +
> " and '2009-08-31' "
> +
> " and absenceType =
> :absenceType ";
> Query query = HibernateConnection .session. createQuery( hql)
> .setParameter("employee",employee)
> .setParameter("absenceType",absenceType) ;
>
>
>
--
syaiful.mukhlis
gtalk:syaiful.mukh...@gmail.com
