Thanks!
On 4 Bir, 20:13, Fabio Maulo <[email protected]> wrote:
> see IProjection.SqlFunction
>
> 2009/6/4 Darius Damalakas <[email protected]>
>
>
>
>
>
> > Great! Thanls Fabio for the HQL examples, these helps me alot and
> > saves a lot of time searching internet. I am actually having problems
> > even googling for NH documentation. (i hope it's just my fault :), and
> > not overal lack of documentation).
>
> > Coul you please give an example how to use month HQL keyword with
> > CriteriaAPI?
>
> > I am actually building a customizable charting form, where you can
> > choose filters dynamically browsing through all applicaion model
> > hierarchy, so HQL is not that suitable here, although technically
> > feasible
>
> > On Jun 4, 3:44 pm, Paulo Quicoli <[email protected]> wrote:
> > > hehehe Fábio, i guess everyone that came from Delphi to .net + Nhibernate
> > > have used tiOPF or IO... i did that too!!! hehehhe
>
> > > :)
>
> > > 2009/6/4 Fabio Maulo <[email protected]>
>
> > > > ex delphi user, ex moderator of "Delphi avanzado", ex developer of some
> > > > DevExpress "extension components"...After study tiOPF<
> >http://tiopf.sourceforge.net/>and InstantObject ... well... you know NH
> > is another thing ;)
>
> > > > 2009/6/4 Paulo Quicoli <[email protected]>
>
> > > >> Hi Fabio!
>
> > > >> so, you are an "ex delphi user" ! I still use delphi :)
>
> > > >> bye!
>
> > > >> 2009/6/4 Fabio Maulo <[email protected]>
>
> > > >>> For EXTRACT is better if you use the HQL function (HQL are
> > multi-RDBMS)select
> > > >>> count(*), month(a.FinishDate), year(a.FinishDate) .......
>
> > > >>> NH will translate "month(a.FinishDate)" with the appropriate FB
> > sentence.
>
> > > >>> 2009/6/4 Darius Damalakas <[email protected]>
>
> > > >>>> I am issuing a query with groups tasks by the month they where
> > > >>>> finished.
> > > >>>> However, this sql is in plain sql. Is it possible to use firebird
> > > >>>> function EXTRACR with HQL or CriteriaAPI?
>
> > > >>>> This is my original query:
> > > >>>> IList results = session.CreateSQLQuery(
> > > >>>> @" SELECT count(*),
> > > >>>> EXTRACT (MONTH FROM a.FINISH_DATE) as mmonth,
> > > >>>> EXTRACT (Year FROM a.FINISH_DATE) as yyear
> > > >>>> FROM PUV_TASK a
> > > >>>> GROUP BY mmonth,
> > > >>>> yyear
> > > >>>> order by
> > > >>>> yyear, mmonth").List();
>
> > > >>>> Thanks!
>
> > > >>> --
> > > >>> Fabio Maulo
>
> > > >> --
> > > >> Paulo R. Quicoli
>
> > > >> Editor Técnico - ClubeDelphi Magazine - DevMedia
>
> > > > --
> > > > Fabio Maulo
>
> > > --
> > > Paulo R. Quicoli
>
> > > Editor Técnico - ClubeDelphi Magazine - DevMedia
>
> --
> Fabio Maulo
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/nhusers?hl=en
-~----------~----~----~----~------~----~------~--~---
