RE: [ic] nested loop and query

["Daniel Davenport" <suppressed>]

> -----Original Message-----
> From: suppressed 
> [mailto:suppressed On Behalf 
> Of Kevin Walsh
> Sent: 2006 August 31 -- Thursday 1:16 PM
> To: suppressed
> Subject: Re: [ic] nested loop and query
> 
> Marko Kuzio <suppressed> 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

_______________________________________________
interchange-users mailing list
suppressed
http://www.icdevgroup.org/mailman/listinfo/interchange-users