Andreas,
BasePeer.executeQuery("...") returns a com.workingdogs.village.Record
object. To get the value from that you need to do something like :-
$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>