Sorry, I had a missunderstanding, it works this way:
...
<if test="id != -1">
and x.id = #{id}
</if>
...
Andreas Niemeyer schrieb:
> Hi,
>
> how can I deal with numeric class properties for dynamic sql in iBatis
> 3.x? In the older 2.x release there exist a `<isGreaterThan>' tag and
> the user guide for 3.x only mentioned the <if> condition. For that, I
> get a NumberFormatException:
>
> Caused by: java.lang.NumberFormatException: For input string: "{0=null}"
>
>
> The example looks like:
>
> <select id="getSomeList" resultType="SomeClass"
> parameterType="SomeConditionClass">
> select
> <include refid="someColumns"/>
> from
> hmm_t t, context_x x
> where
> t.id = x.id_hmm
>
> <if test="#{id} != -1">
> and x.id = #{id}
> </if>
>
> </select>
>
>
> Thank you in advance,
> Andreas
---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org
|