Try $thresholdValue$
On Mon, Apr 27, 2009 at 5:43 PM, Alex Sherwin
<alex.sher...@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***
>>
>>
>
>
