2009/12/15 Diego Mijelshon <[email protected]> > - If from and until are parameters, they should be prefixed with ":" > me, blind
> - Your missing your group by clause > aw, hm, what should I group by? l? > - It would be useful to have the actual error you're getting > it's just telling the query isn't valid, nothing else. It's the one durig session factory creation that isn't actually chatty. 99% sure it refers to both errors you've found. > > > 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]<nhusers%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/nhusers?hl=en. > -- 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]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
