Your iterate tag needs to specify what its iterating. I forget off the top of my head, but I think it's the value attribute.
"<iterate conjunction=" union all " value="values"> select * from task_url_$values[]$</iterate>" -----Original Message----- From: Eugeny N Dzhurinsky [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 19, 2006 6:33 AM To: [email protected] Subject: Re: dynamic tables names in query problem On Tue, Sep 19, 2006 at 04:01:38PM +0300, Eugeny N Dzhurinsky wrote: > I'm trying to do this: > > <statement id="prepareView" parameterClass="list"> > create temporary view task_url_view as > <dynamic> > <iterate conjunction=" union all "> > select * from task_url_$values[]$ > </iterate> > </dynamic> > </statement> > > but this seems not work - > weird exception is thrown: ERROR - relation task_url_$1 does not > exists > > I'm calling this statement as SqlMapClient.update("prepareView",list). Sorry, I missed - in the SQL map there is select * from task_url_#values[]# with $values[]$ it doesn't want to work at all, complaining : ERROR - There is no READABLE property named 'values' in class 'java.util.ArrayList' -- Eugene N Dzhurinsky
