ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Eric Williams <er...@sandiego.com>
Subject RE: Dynamic statements
Date Tue, 22 Mar 2005 00:45:33 GMT
Ah, I see. Yes, I was hoping I could get the parameters parsed as well. I'll
just tell them it'll have to be static, or we'll have to write some JDBC
code.

Thanks for your help!

-Eric

-----Original Message-----
From: Brice Ruth [mailto:bdruth@gmail.com]
Sent: Monday, March 21, 2005 12:43 PM
To: ibatis-user-java@incubator.apache.org
Subject: Re: Dynamic statements


Lemme qualify that ... does your SQL from the database, by your
power-users, have parameters and such specified? I don't think that
will work, if so ... if its static, tho - that should work.


On Mon, 21 Mar 2005 14:41:46 -0600, Brice Ruth <bdruth@gmail.com> wrote:
> I would think so ... if you have a query that returns a String ... or
> you assemble your SQL somehow ... then use $paramName$ in your dynamic
> query, and have remapResults="true" ... you should be golden.
> 
> I can't think of any reason you wouldn't be.
> 
> 
> On Mon, 21 Mar 2005 11:11:38 -0800, Eric Williams <ericw@sandiego.com>
wrote:
> > This might be a bonehead question, but with all the cool new features in
> > iBATIS, particularly those involving dynamic SQL, is it possible to make
the
> > *entire* statement body dynamic? My paramaterClass and resultClass will
> > always be the same, but I'd like to pull the actual SQL, which has been
> > written by my power users, from the database (via another statement, of
> > course). Can this be done?
> >
> > Regards,
> >         Eric
> >
>

Mime
View raw message