RE: dynamic tables names in query problem

2006-09-25 Thread Poitras Christian
- From: Eugeny N Dzhurinsky [mailto:[EMAIL PROTECTED] Sent: Tuesday, 19 September 2006 11:04 To: user-java@ibatis.apache.org Subject: Re: dynamic tables names in query problem On Tue, Sep 19, 2006 at 03:56:43PM +0200, Niels Beekman wrote: Try using $value[]$ or maybe $[]$. Using #'s is probably

Re: dynamic tables names in query problem

2006-09-19 Thread Eugeny N Dzhurinsky
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

RE: dynamic tables names in query problem

2006-09-19 Thread Niels Beekman
: 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

RE: dynamic tables names in query problem

2006-09-19 Thread Daniel Pitts
: Tuesday, September 19, 2006 6:33 AM To: user-java@ibatis.apache.org 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

Re: dynamic tables names in query problem

2006-09-19 Thread Eugeny N Dzhurinsky
On Tue, Sep 19, 2006 at 03:56:43PM +0200, Niels Beekman wrote: Try using $value[]$ or maybe $[]$. Using #'s is probably not going to work, since most databases do not support dynamic tablenames. The $[]$ solved problem, but $value[]$ doesn't work for some reason. -- Eugene N Dzhurinsky