No change Graeme, still no items returned (should be 1 row returned for a fii value of 2)
-----Original Message----- From: Graeme J Sweeney [mailto:[EMAIL PROTECTED] Sent: 03 November 2006 14:45 To: iBatis List Subject: RE: Ibatis not returning any results 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 -
