Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (athena.apache.org: domain of lists@nabble.com designates
 216.139.236.158 as permitted sender)
Message-ID: <27354145.post@talk.nabble.com>
Date: Thu, 28 Jan 2010 02:55:45 -0800 (PST)
From: suprememenu <shaikhid@gmail.com>
To: user-java@ibatis.apache.org
Subject: RE: how to concate a string in insert statement using ibatis?
In-Reply-To: <27353835.post@talk.nabble.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
References: <27353435.post@talk.nabble.com>
 <000c01caa002$36882030$a3986090$@com> <27353818.post@talk.nabble.com>
 <27353835.post@talk.nabble.com>


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