The Firebird dialect has all function registered ;) (at least for FB2.0)Probably it is one of the most complete dialect in term of functions registered (I'm ex "Delphian").
2009/6/4 Darius Damalakas <[email protected]> > > 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! > > > -- 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 -~----------~----~----~----~------~----~------~--~---
