[ic] nested loop and query

[Daniel Davenport]

> -----Original Message-----
> From: interchange-users-bounces at icdevgroup.org 
> [mailto:interchange-users-bounces at icdevgroup.org] On Behalf 
> Of Kevin Walsh
> Sent: 2006 August 31 -- Thursday 1:16 PM
> To: interchange-users at icdevgroup.org
> Subject: Re: [ic] nested loop and query
> 
> Marko Kuzio <marko.kuzio at kochan.de> wrote:
> >  [loop list="germany,polska" interpolate=1]
> > <b>[loop-code]</b>
> > [query sql="select subregion from regions where land = 
> [loop-code]'" 
> > type=list]
> >  [list]
> >    [sql-param subregion] -       
> >   [/list]
> >  <br/>
> >  [/loop]
> > 
> >  the sql query results records via pl-sql client.
> > can i not use the loop and query tag nested?
> > 
> Remove the interpolate=1 parameter from your [loop] tag.

May also want to add a table="regions" to the query tag.  I've had
problems before when not specifying the table, particularly when the
table being queried wasn't one of the product tables.

--
Daniel Davenport
New Age Digital
http://www.newagedigital.com