I'm not really sure how I would go about this, but I'll think about it when I have time to get back to that code.
Thanks, Oliver. Chas. Oliver Lambert wrote: > Is there anything to stop you defining an class/entity {answer: String, > countAnswer: Int} and to directly create it from JPA (of course, it's > read only). > > On Wed, Apr 22, 2009 at 9:36 AM, Charles F. Munat <c...@munat.com > <mailto:c...@munat.com>> wrote: > > > I was thinking tuples, but that didn't work. I'll try your suggestion. > BTW, for anyone reading along, I forgot the group by clause in the query > below. > > Chas. > > Derek Chen-Becker wrote: > > I think that the type would be Array[Any] and you'll get one > String and > > Int for each row. > > > > Derek > > > > On Tue, Apr 21, 2009 at 3:37 PM, Charles F. Munat <c...@munat.com > <mailto:c...@munat.com> > > <mailto:c...@munat.com <mailto:c...@munat.com>>> wrote: > > > > > > Anyone have a quick example of how to run a scalar query in > JPA? I can't > > find anything in the JPA demo. > > > > I have this query: > > > > select t.answer, count(distinct answer) from Vote t where > t.poll = :poll > > order by t.answer > > > > but how do I call it? I normally do: > > > > Model.createNamedQuery[...]("findVoteCountAnswersByPoll", > "poll" -> > > poll).findAll > > > > But what is the type? And how do I get the results back out? > > > > I know I did this once before somewhere, but I can't remember > where and > > I can't find it. > > > > Thanks! > > > > Chas. > > > > > > > > > > > > > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Lift" group. To post to this group, send email to liftweb@googlegroups.com To unsubscribe from this group, send email to liftweb+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/liftweb?hl=en -~----------~----~----~----~------~----~------~--~---