of course...i am stupid... rollback the last message :)


2008/9/11 Ayende Rahien <[EMAIL PROTECTED]>:
> Take a look at the SQL that is being generated.
> You are doing a join across tables. NHibernate is getting the duplicate
> values back, and is treating them as results of the query, which it
> faithfully translate to the actual result set that you are getting.
>
> On Thu, Sep 11, 2008 at 4:57 PM, Ricardo Borges <[EMAIL PROTECTED]>
> wrote:
>>
>> Really?
>>
>> But the where conditions are not "OR" but "AND". For me, this behavior
>> doesn't make sense.
>>
>>
>>
>> 2008/9/11 Roger Kratz <[EMAIL PROTECTED]>:
>> >
>> > This is the default behavior of nhib.
>> >
>> > Use SetResultTransformer(CriteriaUtil.DistinctRootEntity) or wrap the
>> > result in HashSet<T> or similar.
>> >
>> > -----Original Message-----
>> > From: [email protected] [mailto:[EMAIL PROTECTED] On
>> > Behalf Of Ricardo Borges
>> > Sent: den 11 september 2008 14:35
>> > To: [email protected]
>> > Subject: [nhusers] Re: HQL returning duplicated objects
>> >
>> >
>> > Something like:
>> >
>> > from Father as f
>> > where f.code = :code and
>> >         f.Son.name like :name and
>> >         f.otherCode = :otherCode and
>> >         f.Son.Son.code =:sonCode
>> >
>> > thanks!
>> >
>> >
>> >
>> >
>> > 2008/9/10 Ayende Rahien <[EMAIL PROTECTED]>:
>> >> What is you query?
>> >>
>> >> On Thu, Sep 11, 2008 at 4:03 AM, Ricardo Borges
>> > <[EMAIL PROTECTED]>
>> >> wrote:
>> >>>
>> >>> http://jira.nhibernate.org/browse/NH-300
>> >>>
>> >>> My Hql is returning duplicated objects as reported in the closed
>> >>> NH-300, I put a "distintic", this is the "solution" ?
>> >>>
>> >>>
>> >>> []'s
>> >>>
>> >>>
>> >>> Ricardo
>> >>>
>> >>>
>> >>
>> >>
>> >> >
>> >>
>> >
>> >
>> >
>> >
>> > >
>> >
>>
>>
>
>
> >
>

--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to