Dear members,

When i'm using an hql
such as :

string hql = "SELECT Cat.Id,Cat.Cat,Cat.Status,Cat.cathasparent FROM nhExhibition.Business.Category as Cat";
session.find(hql);

where Cat.Id is of type int
Cat.Cat is of type string
Cat.Status of type boolean
Cat.cathasparent of type Category

I'm getting a List of objects (categories) which Cat.cathasparent is different than null ..
In other words, i'm getting a List of all the Category objects except those who have the Cat.cathasparent value = null ...
But i want to retrieve all the Category objects (including those having Cat.cathasparent value = null) ...

how it can be done ?

Regards,
Jojo

You aren't getting all Categories ?
you don't need to specify the properties you need.
Just to know, do you have any category with null hasparentcat?

Dear anuarneto,

i'd like to get some properties of all the "categories objects" (table) from the database ..

and yes, i'm getting the category objects having cathasparent != null ..
those (categories) having the null values aren't retrieved from the database .

how can achieve that ?

Regards,
Jojo

Can You post the generated SQL?

Gert

Add an explicit left join to your query, "SELECT Cat.Id,Cat.Cat,Cat.Status,chp FROM nhExhibition.Business.Category as Cat left join Cat.cathasparent as chp"

Thanks a lot Sergey, It worked like a charm .
But can you please explain me about it ..?

i'm using sqlserver express 2005, and i thought that the joints are required only with MsAccess Database .. i thought that i could avoid these joints by using the "select from ... where ..=(select ... from ..) "
and i've read some topics about joins,which says that it is required when using MS Access only .

Anyway, this join has worked well although i didn't define anything related to the joins in my mapping files :|, shall i add properties to my mapping files inn order to use these joints ?

Is there any query composer, or something which helps in composing my HQl s graphically and get the query?

Thanks in advance, :D

by the way, thanks gert for the last reply

Regards,
Jojo Rico