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
