Thanks! I've found and example here http://nhforge.org/blogs/nhibernate/archive/2009/03/13/registering-freetext-or-contains-functions-into-a-nhibernate-dialect.aspx
i will play with it :) Bye On 4 Bir, 10:37, Tuna Toksoz <[email protected]> wrote: > You can register it in the dialect i believe. > > Tuna Toksöz > Eternal sunshine of the open source mind. > > http://devlicio.us/blogs/tuna_toksozhttp://tunatoksoz.comhttp://twitter.com/tehlike > > On Thu, Jun 4, 2009 at 10:17 AM, Darius Damalakas < > > [email protected]> wrote: > > > 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! --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
