hi , i mean its inserting the database but with value as abc?orderId it should insert into db as abc123 (where 123 is the orderId)
suprememenu wrote: > > 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--tp27353435p27353835.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
