-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 4 posts ] 
Author Message
 Post subject: Wildcard in hbm
PostPosted: Mon Jan 08, 2007 8:11 am 
Newbie

Joined: Wed Dec 20, 2006 6:45 am
Posts: 3
Hi,

Can you please let me know how can we use wildcard character in hbm.xml
Eg:

Select name,
rno, city
from details
where city like "ATL%"

Just want to know about the syntax of where city like "ATL%"

It doesnt work. If I write where city like "ATLANTA", then it works.....


Top
 Profile  
 
 Post subject: Percent
PostPosted: Mon Jan 08, 2007 8:43 am 
Beginner
Beginner

Joined: Wed Aug 31, 2005 3:54 am
Posts: 45
Use an XML unicode caracter for percent :
http://www.natural-innovations.com/wa/doc-charset.html


Top
 Profile  
 
 Post subject: Is it ok ?
PostPosted: Tue Jan 09, 2007 9:00 am 
Beginner
Beginner

Joined: Wed Aug 31, 2005 3:54 am
Posts: 45
Is it working ?

Don't forget to rate ;-)


Top
 Profile  
 
 Post subject: Re: Is it ok ?
PostPosted: Tue Jan 16, 2007 6:35 am 
Newbie

Joined: Wed Dec 20, 2006 6:45 am
Posts: 3
Thnx a ton.. It worked... :-))

asic wrote:
Is it working ?

Don't forget to rate ;-)


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 4 posts ] 

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

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.