ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alex Sherwin <alex.sher...@acadiasoft.com>
Subject Re: problem with the parameter in select clause
Date Mon, 27 Apr 2009 13:43:10 GMT
#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