It's IBatis 3. Here is the statement: <select id="selectByUsernameAndPassword" parameterType="domain.ClockUser" resultType="domain.ClockUser"> SELECT users.id, users.username, users.password, MAX(clock_operations.date) as lastActionDate, clock_operations.clock_in as clockedIn FROM users, clock_operations WHERE users.id=clock_operations.user_id AND users.username=#{username} AND users.password=#{password}; </select>
Larry Meadors wrote: > > Maybe with some info. > > Using ibatis2 or 3? > > Can you provide your mapped statement? > > Throw us a bone here. :P > > Larry > > > On Mon, May 3, 2010 at 3:09 AM, vadboss <vadb...@gmail.com> wrote: >> >> I have in the table a boolean (tinyint(1)) value. I don't know why, but >> ibatis always gets it as true, whether it is 0, or 1 in database. >> >> Who knows what is the cause? >> -- >> View this message in context: >> http://old.nabble.com/IBatis%3A-boolean-mapping-misunderstanding-tp28432952p28432952.html >> Sent from the iBATIS - User - Java mailing list archive at Nabble.com. >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org >> For additional commands, e-mail: user-java-h...@ibatis.apache.org >> >> > > --------------------------------------------------------------------- > To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org > For additional commands, e-mail: user-java-h...@ibatis.apache.org > > > -- View this message in context: http://old.nabble.com/IBatis%3A-boolean-mapping-misunderstanding-tp28432952p28434308.html Sent from the iBATIS - User - Java mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org