ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nicholoz Koka Kiknadze <kikna...@gmail.com>
Subject Re: problem with the parameter in select clause
Date Mon, 27 Apr 2009 13:50:44 GMT
Try $thresholdValue$


On Mon, Apr 27, 2009 at 5:43 PM, Alex Sherwin
<alex.sherwin@acadiasoft.com>wrote:

> #thresholdValue# will put '100' in the SQL that is created (note: with
> single quotes, making it a non-number value)
>
> I assume what you want is to use $thresholdValue$, which will explicitly
> insert that value from your map as: 100 (no quotes, etc)
>
>
>
> Vasantha Rapuru wrote:
>
>>
>> Hi All,
>>
>> Below is my query. When I tried to run this in Ibatis, its throwing an
>> exception saying *Syntax Error Occured*.
>>
>> <select id="searchQuery" resultMap="cityresult" parameterClass="map">
>>
>> select first #thresholdValue#  cityName
>> from city;
>>  </select>
>>
>> ThresholdValue is set in the map as given below:
>>
>> paramMap.put("thresholdValue",100);
>>
>>
>> Can anybody help to solve this problem.
>>
>> Thanks & Regards,
>>
>> Vasantha
>>
>> **************** CAUTION - Disclaimer *****************
>> This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended
>> solely for the use of the addressee(s). If you are not the intended
>> recipient, please notify the sender by e-mail and delete the original
>> message. Further, you are not to copy, disclose, or distribute this e-mail
>> or its contents to any other person and any such actions are unlawful. This
>> e-mail may contain viruses. Infosys has taken every reasonable precaution to
>> minimize this risk, but is not liable for any damage you may sustain as a
>> result of any virus in this e-mail. You should carry out your own virus
>> checks before opening the e-mail or attachment. Infosys reserves the right
>> to monitor and review the content of all messages sent to or from this
>> e-mail address. Messages sent to or from this e-mail address may be stored
>> on the Infosys e-mail system.
>> ***INFOSYS******** End of Disclaimer ********INFOSYS***
>>
>>
>
>

Mime
View raw message