ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From suprememenu <shaik...@gmail.com>
Subject Re: how to concate a string in insert statement using ibatis?
Date Thu, 28 Jan 2010 09:55:52 GMT



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-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org


Mime
View raw message