Hibernate Community • View topic - comparing a string with an int in hql queries?

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

comparing a string with an int in hql queries?

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

pchandrasekhar

Post subject: comparing a string with an int in hql queries?

Posted: Mon Apr 25, 2005 2:49 am

Newbie

Joined: Mon Apr 25, 2005 2:45 am
Posts: 1

Hi all,

I have a values (01,02,03,04,05 etc) stored in the db as strings. i am forced to store them as strings because of a few constraints in the framework I am using. is there a way to compare these values which are stored as strings in the db to integers in hql queries?

like...

select from abc where '01' > :1 where :1 os an integer?
thanks

Top

snpesnpe

Post subject:

Posted: Mon Apr 25, 2005 10:32 am

Expert

Joined: Sat Jun 12, 2004 4:49 pm
Posts: 915

Try it ?

I think that it work if your database support type conversion (oracle do it)

regards

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum