You need to group by all the User properties.
Diego
On Thu, Dec 9, 2010 at 12:49, W3Max <[email protected]> wrote:
> BTW, have you read the last comment on stackoverflow?
> The answer you gave does not work.
>
> On Dec 8, 2:59 pm, Diego Mijelshon <[email protected]> wrote:
> > BTW, here's the stackoverflow question, which I've already answered last
> > week:
> http://stackoverflow.com/questions/4351683/how-can-i-do-this-query-wi...
> >
> > Funny, the solution is... a view :-D
> >
> > DiegoOn Tue, Dec 7, 2010 at 21:35, Mohamed Meligy <
> [email protected]> wrote:
> > > @W3Max
> >
> > > >> Thanks for nothing.
> >
> > > Please don't get me wrong, but I really would avoid using
> > > this statement (especially in public) at "all" times. Not trying to
> tell you
> > > what to do (sorry if sounds so), but really the guy is just trying to
> help
> > > in the way he sees appropriate. He sounds like saying that maybe you
> need to
> > > add some unit tests to capture such behaviors earlier or with better
> > > feedback or so ....
> >
> > > >> Come on, I thought the user group would have been more friendly. Did
> I
> > > insulted you by asking this question?
> >
> > > Well, welcome to nhusers group. That's just how it is.
> >
> > > *Mohamed Meligy
> > > *Readify | Senior Developer
> >
> > > M:+61 451 835006 | W:www.readify.net
> > > [image: Description: Description: Description: Description: rss_16]
> [image:
> > > Description: Description: Description: Description:
> > > cid:[email protected]] <http://www.linkedin.com/in/meligy>
> [image:
> > > Description: Description: Description: Description:
> > > cid:[email protected]] <http://twitter.com/meligy>
> > > <http://www.greatplacetowork.com.au/best/best-companies-australia.php
> ><http://www.readify.net/AboutUs/NewsItem.aspx?id=10>
> >
> > > On Wed, Dec 8, 2010 at 11:11 AM, W3Max <[email protected]> wrote:
> >
> > >> I don't understand why you take some time to answer the question and
> > >> buck on some words I maybe misused!?
> > >> I don't care about using HQL as long as it works! And what is this
> > >> thing about unit tests ?
> >
> > >> Come on, I thought the user group would have been more friendly. Did I
> > >> insulted you by asking this question?
> >
> > >> Thanks for nothing.
> >
> > >> By the way, I resolved my problem by using a view.
> >
> > >> On Dec 6, 10:19 pm, Fabio Maulo <[email protected]> wrote:
> > >> > what mean, for you, "magic string"?
> > >> > if you will have an exception, for a wrong query, during the
> start-up
> > >> > of your application, in your opinion, is an HQL a "magic string"?
> >
> > >> > P.S. If you have, at least, a test for that query perhaps a "magic
> > >> > string" can be only a mirage.
> >
> > >> > --
> > >> > Fabio Maulo
> >
> > >> > El 06/12/2010, a las 21:14, W3Max <[email protected]> escribió:
> >
> > >> > > Can you help me with this query (I'm using NHibernate 3 +
> > >> > > FluentNhibernate AutoMappings)
> >
> > >> > > Copied from stackoverflow :
> > >>http://stackoverflow.com/questions/4351683/how-can-i-do-this-query-wi.
> ..
> >
> > >> > > How can I do this query with NHibernate
> >
> > >> > > select top 10 count(distinct classedition.createdby_id) as
> editions,
> > >> > > class.id,
> > >> > > class.name, class.createdon, class.createdby_id
> > >> > > from class
> > >> > > inner join classedition on class.id = classedition.class_id
> > >> > > group by class.id, class.name, class.createdon,
> class.createdby_id
> > >> > > order by editions desc, class.createdon desc
> >
> > >> > > I'm using NHibernate 3. I tried to do it with the new Linq
> provider
> > >> > > without success. I don't care about the way of doing it as long as
> it
> > >> > > produce the exact sql query above. I would prefer writing a
> strongly
> > >> > > typed query, without magic string if possible.
> >
> > >> > > I'm new to NHibernate so this question may be simple.
> >
> > >> > > Here is a little more info
> >
> > >> > > I use Fluent NHibernate with AutoMappings. The C# classes are very
> > >> > > simple:
> >
> > >> > > public class Class
> > >> > > {
> > >> > > public virtual int Id { get; set; }
> > >> > > public virtual string Name { get; set; }
> > >> > > public virtual DateTime CreatedOn { get; set; }
> > >> > > }
> >
> > >> > > public class ClassEdition
> > >> > > {
> > >> > > public virtual int Id { get; set; }
> > >> > > public virtual Class Class { get; set; }
> > >> > > public virtual User CreatedBy { get; set; }
> > >> > > }
> >
> > >> > > public class User
> > >> > > {
> > >> > > public virtual int Id { get; set; }
> > >> > > public virtual string Name { get; set; }
> > >> > > }
> >
> > >> > > --
> > >> > > 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]>
> <nhusers%[email protected]<nhusers%[email protected]>>
> > >> .
> > >> > > For more options, visit this group athttp://
> > >> 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]>
> <nhusers%[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]>
> <nhusers%[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.
