Hibernate Community • View topic - How to use Like operator?

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]

How to use Like operator?

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

fahiemulleh

Post subject: How to use Like operator?

Posted: Mon Jul 03, 2006 2:44 pm

Newbie

Joined: Mon Jul 03, 2006 2:38 pm
Posts: 1

Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

How to use LIke operator:

Dear All,

I want to query about how to use like operator in NHibernate.

"objLookupValueBO.HeadId.Head Like :varHead". I want to embed it with a percentage % sign as in SQL. but i cant know how to do it. Some class fellow has told me to use SEPARATE_PERCENTAGE. BUT I dont know exactly how to use it.

Top

mojarrell

Post subject:

Posted: Tue Jul 04, 2006 11:18 am

Beginner

Joined: Mon Jul 26, 2004 4:29 pm
Posts: 45
Location: TX, USA

Hi,

From section 15.8 of the reference manual (ver 3.0.5):

Quote:

Scalar SQL functions supported by the underlying database may be used

Code:

from DomesticCat cat where upper(cat.name) like 'FRI%'

Hope this helps,

Top

benhyrman

Post subject:

Posted: Tue Jul 04, 2006 5:44 pm

Regular

Joined: Wed Jun 21, 2006 3:13 pm
Posts: 110

This is hokey, but here's one way to do it with a parameterized query:

Code:

string sql = "from Account where Username like :username";
IQuery query = DbSessionContext.Current.Session.CreateQuery(sql);
query.SetString("username", username + '%');

Top

Page 1 of 1

[ 3 posts ]

Board index » Hibernate & Java Persistence » NHibernate 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