yes, i've done that already, and i've overcome this problem. as far as i understand the problem, it's HQL parser which does not understand how to treat numbers with 'm' in the end, am i right?
On 29 Bal, 08:26, Ayende Rahien <[email protected]> wrote: > Darius,Create another overload for the TurnoverRecord, that would be easiest > > On Wed, Apr 29, 2009 at 8:25 AM, Darius Damalakas < > > [email protected]> wrote: > > > I've tried again to use 0.0m, but here is what i've got: > > "NHibernate.QueryException: undefined alias or unknown mapping: 0" > > > This is the full HQL and stack trace: > > > NHibernate.QueryException: undefined alias or unknown mapping: 0 [ > > select new TurnoverRecord(billPayment.RecipientBillPlan.Id , > > sum(billPayment.AmountNoPVM) , sum(billPayment.AmountTotal) , 0.0m) > > from PUV.BLL.Model.BillPayment billPayment > > left join billPayment.BillPaymentType as billPaymentType > > left join billPaymentType.BillPaymentSubtype as billPaymentSubType > > left join billPayment.PayerItem as payerItem > > left join payerItem.ParentItem as parentItem1 > > left join parentItem1.ParentItem as parentItem2 > > left join billPayment.ForTask as forTask > > left join forTask.DistributionType as taskDistributionType > > left join billPayment.RecipientContract as recipientContract > > left join recipientContract.DistributionType as > > recipientContractDistributionType > > > where billPayment.Date >= :fromDate and billPayment.Date <= :toDate > > and billPayment.RecipientCompany = :recipientCompany and > > (billPaymentSubType.UniqueCode = > > 'BillPaymentSubType_IntermediateData') and > > taskDistributionType.UniqueCode != DistributionType_InvisibleToPayers > > and recipientContractDistributionType.UniqueCode != > > DistributionType_InvisibleToPayers and billPayment.RecipientCompany > > != billPayment.PayerCompany > > group by billPayment.RecipientCompany , > > billPayment.RecipientBillPlan > > ] > > at NHibernate.Hql.Classic.PathExpressionParser.Token(String token, > > QueryTranslator q) > > at NHibernate.Hql.Classic.ParserHelper.Parse(IParser p, String > > text, String seperators, QueryTranslator q) > > at NHibernate.Hql.Classic.SelectParser.Token(String token, > > QueryTranslator q) > > at NHibernate.Hql.Classic.ClauseParser.Token(String token, > > QueryTranslator q) > > at NHibernate.Hql.Classic.ClauseParser.End(QueryTranslator q) > > at NHibernate.Hql.Classic.PreprocessingParser.End(QueryTranslator q) > > at NHibernate.Hql.Classic.ParserHelper.Parse(IParser p, String > > text, String seperators, QueryTranslator q) > > at NHibernate.Hql.Classic.QueryTranslator.Compile() > > at NHibernate.Hql.Classic.QueryTranslator.Compile(IDictionary`2 > > replacements, Boolean scalar) > > at NHibernate.Engine.Query.HQLQueryPlan..ctor(String hql, String > > collectionRole, Boolean shallow, IDictionary`2 enabledFilters, > > ISessionFactoryImplementor factory) > > at NHibernate.Engine.Query.QueryPlanCache.GetHQLQueryPlan(String > > queryString, Boolean shallow, IDictionary`2 enabledFilters) > > at NHibernate.Impl.AbstractSessionImpl.GetHQLQueryPlan(String > > query, Boolean shallow) > > at NHibernate.Impl.AbstractSessionImpl.CreateQuery(String queryString) > > at PUV.Helpers.BillPayments.Remainders.FluentHQL.Select[K]() in > > > Any other ideas? > > > For the moment, i will make a dirty hack - i will make some more > > constructors, but would be nice to solve this little nuisance > > > 2009/4/28 Darius Damalakas <[email protected]>: > > > i've tried this already, but with no success. I will try again your > > > suggestion, maybe i just made a simple mistake or something. I will > > > let you know if it helps > > > > 2009/4/28 Germán Schuager <[email protected]>: > > >> Try "0m" instead of "0.0" > > > >> On Tue, Apr 28, 2009 at 11:47 AM, Darius Damalakas > > >> <[email protected]> wrote: > > > >>> Hi everybody, > > > >>> I've checked HQL docs, but can't find a solution (http://nhforge.org/ > > >>> doc/nh/en/index.html#queryhql-expressions). > > > >>> I have query which goes like this: > > > >>> select new Record(billPlan.Id, 0.0) > > >>> from BillPlan billPlan > > > >>> my class Record has a contstuctor, which takes first parameter as > > >>> Int32, and second as decimal. > > >>> However, NHibernate seems to argue, that 0.0 is not a decimal, but a > > >>> double instead. > > > >>> How should i tell that i want to select a constant decimal value for > > >>> the second constructor argument? > > > > -- > > > Darius Damalakas > > > -- > > Darius Damalakas --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Castle Project Users" 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/castle-project-users?hl=en -~----------~----~----~----~------~----~------~--~---
