Thanks Markus that worked perfectly On Sun, Jun 13, 2010 at 1:10 PM, Markus Zywitza <[email protected]>wrote:
> http://nhforge.org/doc/nh/en/index.html#queryhql-select > > select *elements(*p.Categories*)* from Product p where p.Brand = ? > > -Markus > > Am 13. Juni 2010 11:04:42 UTC+2 schrieb ubahn <[email protected]>: > > Hi Markus, >> >> The problem is that each product can have more than one category and I >> cannot query 'SELECT p.Category'. Is there something in HQL that can >> handle such associations ? >> >> Mark >> >> On Jun 13, 7:30 am, Markus Zywitza <[email protected]> wrote: >> > Why don't you use HQL for that, it is dead simple: >> > >> > select p.Category from Product p where p.Brand = ? >> > >> > -Markus >> > >> > Am 13. Juni 2010 06:43:28 UTC+2 schrieb Mark Borg <[email protected] >> >: >> > >> > >> > >> > > OK Guys, solved using a native SQL query >> > >> > > SELECT * FROM prod_productcategory pc >> > > JOIN prod_productcategories pcs ON pc.id = pcs.productCategoryId >> > > JOIN prod_product p ON pcs.productId = p.id >> > > AND p.productBrandId = :productBrandId; >> > >> > > On Sun, Jun 13, 2010 at 5:57 AM, ubahn <[email protected]> wrote: >> > >> > >> Hi all, >> > >> > >> I have the following model: >> > >> > >> Each Product is linked with a ProductBrand >> > >> Each Product has a HasAndBelongsToMany relationship with >> > >> ProductCategory >> > >> > >> and what I`m trying to retrieve is a list of product categories for a >> > >> given product brand if there are products linked with that brand >> > >> > >> Can someone give me a hand on this one .... >> > >> > >> Thanks >> > >> > > -- >> > > You received this message because you are subscribed to the Google >> Groups >> > > "Castle Project Users" group. >> > > To post to this group, send email to >> [email protected] >> > > . >> > > To unsubscribe from this group, send email to >> > > [email protected]<castle-project-users%[email protected]><castle-project-users%2Bun >> [email protected]> >> > > . >> > > For more options, visit this group at >> > >http://groups.google.com/group/castle-project-users?hl=en. >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Castle Project Users" group. >> To post to this group, send email to >> [email protected]. >> To unsubscribe from this group, send email to >> [email protected]<castle-project-users%[email protected]> >> . >> For more options, visit this group at >> http://groups.google.com/group/castle-project-users?hl=en. >> >> > -- > You received this message because you are subscribed to the Google Groups > "Castle Project Users" group. > To post to this group, send email to [email protected] > . > To unsubscribe from this group, send email to > [email protected]<castle-project-users%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/castle-project-users?hl=en. > -- You received this message because you are subscribed to the Google Groups "Castle Project Users" 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/castle-project-users?hl=en.
