Hi, By the way My query is below "select b.Name as brand,a.Name as eventname,c.Code,a.EventStartDate,a.EventEndDate,a.EventObjective,a.EventTyp e from ASSET a,Brand b,LPDCOUNTRY c where a.Brand=b.id and a.Country=c.id"
It also says brand property not defined...Is there any syntax error...I couldn't find any Thanks in advance Many Thanks and Regards, Jerson From: Jerson John [mailto:jer...@cprvision.com] Sent: Friday, February 18, 2011 10:53 AM To: 'Struts Users Mailing List' Subject: RE: generate SQL Hibernate Query using session Hi, Thanks for your reply. Actually I am bit confused here..What I do normally is that get the List of the model calss from the HQL Query and cast it and iterate it in jsp...Here If there values from more than one table then I can't cast it to any model class because of the difference in properties.Please advice me a approach for this....Thanks in advance Many Thanks and Regards, Jerson -----Original Message----- From: Dave Newton [mailto:davelnew...@gmail.com] Sent: Friday, February 18, 2011 10:34 AM To: Struts Users Mailing List Subject: Re: generate SQL Hibernate Query using session What does having joins have to do with not being able to map to your data model? Dave On Feb 17, 2011 8:43 PM, "Jerson John" <jer...@cprvision.com> wrote: > Hi, > I am trying to generate SQL query using session.createSQLQuery and > returning the list object..This select query contains joins and so it cannot > be mapped to any of my model objects.How can I now get the values in my jsp > page using iterator tag in Struts 2... > > Please help me on this > > Many Thanks and Regards, > > Jerson > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: user-unsubscr...@struts.apache.org > For additional commands, e-mail: user-h...@struts.apache.org > --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscr...@struts.apache.org For additional commands, e-mail: user-h...@struts.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscr...@struts.apache.org For additional commands, e-mail: user-h...@struts.apache.org
