On Wed, 2002-10-23 at 18:15, Peter Courcoux wrote:
> Andreas,
>
> BasePeer.executeQuery("...") returns a com.workingdogs.village.Record
> object. To get the value from that you need to do something like :-
Whoops! No! It does, of course, return a List of
com.workingdogs.village.Record objects.
>
>
>
> $row.getValue("a").asInt() // asString() etc. whatever is appropriate.
> $row.getValue("b").asInt() // asString() etc. whatever is appropriate.
>
> See javadocs at
> http://share.whichever.com/village/village-1.5.3/docs/apidocs/
>
> Hope that helps.
>
> Regards,
>
> Peter Courcoux
>
>
>
>
> On Wed, 2002-10-23 at 09:56, Post, Andreas (FF) wrote:
> > Hello !
> >
> > I need some help for a simple question, I guess.
> > Because I have a very tricky "join,group by" Statement, I want to do it
> > without criteria.
> >
> > I m using the following, and it works:
> >
> > List L=BasePeer.executeQuery("SELECT a,b FROM TABLE");
> > context.put("list", L);
> >
> > but I can�t get the elements in the template:
> >
> > #foreach ( $row in $list )
> > $row.a
> > $row.b
> > #end
> > That would be beautiful, but it doesn't work.
> >
> > Does anybody have an answer to get the collumns ?
> >
> > thank you
> >
> > Greetings
> > Andreas Post
>
>
> --
> To unsubscribe, e-mail: <mailto:turbine-user-unsubscribe@;jakarta.apache.org>
> For additional commands, e-mail: <mailto:turbine-user-help@;jakarta.apache.org>
>
--
To unsubscribe, e-mail: <mailto:turbine-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:turbine-user-help@;jakarta.apache.org>
