Hibernate Community • View topic

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

a query issue

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

abulheath

Post subject: a query issue

Posted: Fri Oct 17, 2003 8:14 pm

Beginner

Joined: Wed Sep 17, 2003 10:25 am
Posts: 36

Hi,

I am having a little query issue that I am sure someone here has faced/resolved. It is really simple. What should I do using the Query interface to do a select using a wildcard '%'?

I am doing this

Query q = session.createQuery("Select count(*) from persistClass as pc where name like %?%");
q.setString(0, "am");

I also tried this:
Query q = session.createQuery("Select count(*) from persistClass as pc where name like %:name%");
q.setString("name", "am");

Both are failing? What is wrong with this syntax?

Thanks...

Top

steve

Post subject:

Posted: Fri Oct 17, 2003 9:37 pm

Hibernate Team

Joined: Tue Aug 26, 2003 3:00 pm
Posts: 1816
Location: Austin, TX

Code:

Query q = session.createQuery("select count(*) from persistClass as pc where pc.name like :name"); 
q.setString("name", "%am%");

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