- If from and until are parameters, they should be prefixed with ":" - Your missing your group by clause - It would be useful to have the actual error you're getting
Diego On Tue, Dec 15, 2009 at 16:32, Jan Limpens <[email protected]> wrote: > hello guys, > > my hql is not so hot... could anyone help me with this query? > > <query name="Orders.CountHowManyTimesTheseArticlesWereBought"> > select sum(l.Quantity), a.Id > from OrderLine l > inner join l.Article as a > inner join l.Order as o > where a.Id in (:articleIds) > and o.Timestamp >= from > and o.Timestamp <= until > </query> > > it won't even compile the way it is... > > -- > Jan > > -- > 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]<nhusers%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/nhusers?hl=en. > -- 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.
