Use dollar signs around value instead of pound signs:
$value$
--- Steven Pannell <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I tried this to execute my dynamic SQL statement but does not work.
> anyone
> an idea how to resolve this???
> The SQL statements have to be built in the java code, so I cannot use
> a
> standard map.
>
>
> <statement id="execute-rule" parameterClass="string"
> resultClass="long" >
> <![CDATA[
> #value#
> ]]>
> </statement>
>
> //Java code
>
> client.insert("execute-rule","insert into myTable(id) values (1)");
>
>
> THX,
> steve.
>
>
> -----Original Message-----
> From: James, Steven [mailto:[EMAIL PROTECTED]
> Sent: 22 March 2005 17:00
> To: [email protected]
> Subject: RE: execute SQL statement that are not in a map
>
>
> 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: '[email protected]'
> 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.
>
