ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andy Thompson" <artho...@gmail.com>
Subject silly question regarding cast from char to int
Date Thu, 15 Feb 2007 22:11:56 GMT
in my database - i've got a value that's of type char.  for example
"0000009".  the dao is passing back a request by id where id is 9.  So
there's no match.

so select * from some_column where database_id = #java_id# returns null.
but select * from some_column where database_id="0000009" returns true.

I'd prefer to not have to modify the dao making the request to add 0s to it
cause that seems dumb and I can't change the database.
what's the easiest resolution here?

Andrew R. Thompson
Currently in D.C. Consulting

View raw message