RE: dynamic tables names in query problem

2006-09-25 Thread Poitras Christian
MAIL 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 not going to work, since

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

RE: dynamic tables names in query problem

2006-09-19 Thread Daniel Pitts
: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: > > > create temporary view task_url_view as > > >

RE: dynamic tables names in query problem

2006-09-19 Thread Niels Beekman
bject: 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: > > > create temporary view task_url_view as > > >

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: > > > create temporary view task_url_view as > > > select * from task_url_$values[]$ > > > > > but this seems not work - > w

dynamic tables names in query problem

2006-09-19 Thread Eugeny N Dzhurinsky
I'm trying to do this: create temporary view task_url_view as select * from task_url_$values[]$ but this seems not work - weird exception is thrown: ERROR - relation task_url_$1 does not exists I'm calling this statem