hi ,
when i try 'abc?orderId?' this its inserting the data like
'abc?orderId?' directlly in the database.
meindert-3 wrote:
>
> Best option is to do it on the java side, otherwise you can use
> 'abc?orderId?' what will insert (sql inject!) the literal value of orderId
> in your query
> -----Original Message-----
> From: suprememenu [mailto:shaik...@gmail.com]
> Sent: 28 January 2010 11:55 AM
> To: user-java@ibatis.apache.org
> Subject: how to concate a string in insert statement using ibatis?
>
>
> hi all,
> i would like to know how can i contact a string in insert statemnet
> using
> ibatis?
>
> insert into knet
> (TRACK_ID,
> STORE_ID,
> order_id
> DATE
> )
> values(
> #trackId#,
> #storeId#,
> 'abc'+#orderId#,
> SYSDATE)
>
>
> i mean for the column orderId i need to add a static string . when i tried
> the above i am getting error ...
> --
> View this message in context:
> http://old.nabble.com/how-to-concate-a-string-in-insert-statement-using-ibat
> is--tp27353435p27353435.html
> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org
> For additional commands, e-mail: user-java-h...@ibatis.apache.org
>
>
> No virus found in this incoming message.
> Checked by AVG - www.avg.com
> Version: 9.0.733 / Virus Database: 271.1.1/2650 - Release Date: 01/27/10
> 21:36:00
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org
> For additional commands, e-mail: user-java-h...@ibatis.apache.org
>
>
>
--
View this message in context:
http://old.nabble.com/how-to-concate-a-string-in-insert-statement-using-ibatis--tp27353435p27353818.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org
For additional commands, e-mail: user-java-h...@ibatis.apache.org
