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>

Reply via email to