you'll probably need to reference the string as $value$, unless you're using a syntax I'm not familiar with.
On Tue, 22 Mar 2005 16:00:05 -0000, James, Steven <[EMAIL PROTECTED]> wrote: > create a generic statement in a sqlmap > <statement id="Execute" parameterClass="string"> > #string > </statement> > > > -----Original Message----- > From: Steven Pannell [mailto:[EMAIL PROTECTED] > Sent: Tue 3/22/2005 3:16 PM > To: 'ibatis-user-java@incubator.apache.org' > Subject: execute SQL statement that are not in a map > > Hi, > > I build some SQL statements in java and want to execute them on the DB. As > I don't have a iBatis-map for these (they are build dynamically) what is the > best way to execute the statements on the db. the SqlMapClient does not have > any kind of execute method. The only thing I came up with at the moment was: > > client.getDataSource().getConnection().prepareStatement(mysql).executeQuery( > ) > > Bit nasty... > > Any ideas? > > Thanks, > Steve. > > This e-mail and any attachment is for authorised use by the intended > recipient(s) only. It may contain proprietary material, confidential > information and/or be subject to legal privilege. It should not be copied, > disclosed to, retained or used by, any other party. If you are not an > intended recipient then please promptly delete this e-mail and any attachment > and all copies and inform the sender. Thank you. >
