Hibernate Community • View topic - "Escape" clause and quotations in HQL?

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

"Escape" clause and quotations in HQL?

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

Guilherme_82

Post subject: "Escape" clause and quotations in HQL?

Posted: Wed Apr 12, 2006 8:25 am

Beginner

Joined: Wed Apr 27, 2005 8:27 am
Posts: 27

Hi everyone,

What is the equivalent clause to 'escape' from SQL in HQL?
ex.: select * from client as cli where cli.name like ('%/%%') escape ('/')

How can I make my query in HQL to find for a field with a ' ?
example with SQL: select * from client cli where cli.name like ('%''%')
in SQL, I must write 2 single quotations (''). Do I have to do the same way in HQL?

Can anybody give me a hint?

thanks, Guilherme

Top

r1ch

Post subject:

Posted: Wed Apr 12, 2006 10:03 am

Regular

Joined: Wed Aug 25, 2004 6:23 am
Posts: 91

I don't think that there is a way to escape it but you could pass it in as a parameter

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