What is returned by to_char(max(position_as_at))?
Larry
On 11/3/06, Graeme J Sweeney <[EMAIL PROTECTED]> wrote:
On Fri, 3 Nov 2006, Rutherford, Matthew [CIB-IT] wrote:
> The java property is of type int. ie. setFii(2) sets it to an int value 2.
In the db it is an oracle number(12).
>
> If I do a getItems (select *) type query The list is populated fine.
>
> Any ideas?
what happens if you hardcode the value of fii ?
<select id="getLatestPositionByFii" resultMap="result">
SELECT id,currency_code,fii, to_char(max(position_as_at)), pos
FROM item
WHERE fii = 2 and pos != 0
GROUP BY id,currency_code,fii,pos
</select>
--
Graeme -
