how to concate a string in insert statement using ibatis?

[suprememenu]

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-ibatis--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