Problem with count(*) in mybatis

[geetha]

i'm facing problem with count(*) in mybatis ... it is always returning
0...

<select id="checkGeoAreaStatusIsInActive" resultType="int"
parameterType="int">
select count(geo_area_id) from GEO_AREA
where status != 'inactive' and geo_area_id = #{value,
jdbcType=INTEGER}
</select>

i have tried to change the query as below but still facing issues.

<select id="checkGeoAreaStatusIsInActive" resultType="int"
parameterType="int">
select count(*) geo_area_id from GEO_AREA
where status != 'inactive' and geo_area_id = #{value,
jdbcType=INTEGER}
</select>

[Larry Meadors]

Try this instead:

select count(*) as value from ...

Larry

[c c]

first you must know if it has data in you table ?

 1，you can print the sql
2, excute the sql use some db tools ,

2012/2/3 geetha <mahi.co...@gmail.com>