Hi,
I solved the issue from java side .
thanks.
suprememenu wrote:
>
> 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--tp27353435p27354145.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
