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:[EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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 > > >
