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

Re: Dynamic tables.

2005-11-02 Thread Larry Meadors
Exactly my point...just better said. :) Larry On 11/2/05, Michael Campbell <[EMAIL PROTECTED]> wrote: > there is a big difference between "The full power of SQL" > and "The power of full SQL".

Re: Dynamic tables.

2005-11-02 Thread Michael Campbell
On 11/2/05, Larry Meadors <[EMAIL PROTECTED]> wrote: > On 11/2/05, Ben Munat <[EMAIL PROTECTED]> wrote: > > Larry Meadors wrote: > > > DDL != SQL :) > > > > > There may be other ways of defining a DDL, but to most people it means > > "create", "drop" > > and "alter", which are ANSI SQL. > > > > It

Re: Dynamic tables.

2005-11-02 Thread Larry Meadors
On 11/2/05, Ben Munat <[EMAIL PROTECTED]> wrote: > Larry Meadors wrote: > > DDL != SQL :) > > > There may be other ways of defining a DDL, but to most people it means > "create", "drop" > and "alter", which are ANSI SQL. > > It seems disingenuous of iBatis to claim it -- as David points out -- >

Re: Dynamic tables.

2005-11-02 Thread Ben Munat
Larry Meadors wrote: DDL != SQL :) There may be other ways of defining a DDL, but to most people it means "create", "drop" and "alter", which are ANSI SQL. It seems disingenuous of iBatis to claim it -- as David points out -- "provides the full power of SQL", when it doesn't support three of

Re: Dynamic tables.

2005-11-02 Thread Larry Meadors
On 11/2/05, David Moss <[EMAIL PROTECTED]> wrote: > Thanks, > > I'm a little disappointed that DDL isn't supported in some shape or > form. After all, iBATIS does claim to provide me with 'the full power > of SQL'. However, I suppose that as iBATIS is aimed at mapping data > objects to relational

Re: Dynamic tables.

2005-11-02 Thread David Moss
Thanks, I'm a little disappointed that DDL isn't supported in some shape or form. After all, iBATIS does claim to provide me with 'the full power of SQL'. However, I suppose that as iBATIS is aimed at mapping data objects to relational tables, perhaps DDL doesn't really fit within the brief

Re: Dynamic tables.

2005-11-01 Thread Larry Meadors
First off, DDL is unsupported. If it works, swell; If not, bummer. You may be able to do the insert using $substitution$ and #parameters# with iterate tags - I have never tried that, but give it a shot - it may work. Larry On 11/1/05, David Moss <[EMAIL PROTECTED]> wrote: > Hi, > > I'm trying t