suprememenu wrote:
>
> 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 ... Cause: java.sql.SQLException: ORA-01722:
> invalid number
>
--
View this message in context:
http://old.nabble.com/how-to-concate-a-string-in-insert-statement-using-ibatis--tp27353435p27353477.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