30 Oct
2008
30 Oct
'08
12:10 p.m.
Hello,
I have a simple question, although I could not find the answer in the
archives or google.
Is it possible to use a [0-9] pattern in the where clause of a HQL
query. Something like:
where doc.title like '[0-9]%'
Hope someone can help me with this.
Thanks,
Henk
==
Henk F. Schouten, ICT-architect, Dienst ICT
room: SL 2.32, phone (31) 70 4457611, email: H.F.Schouten(a)hhs.nl
De Haagse Hogeschool, Johanna Westerdijkplein 75, 2521 EN the Hague (NL)
30 Oct
30 Oct
2:06 p.m.
Henk Schouten wrote:
Hello,
I have a simple question, although I could not find the answer in the
archives or google.
Is it possible to use a [0-9] pattern in the where clause of a HQL
query. Something like:
where doc.title like '[0-9]%'
I don't think so. Hibernate leverages the different SQL syntaxes, and
AFAIK, SQL does not support regular expressions or patterns.
--
Sergiu Dumitriu
http://purl.org/net/sergiu/
31 Oct
31 Oct
3:16 p.m.
You can use only what is supported by standard SQL LIKE syntax and i
doubt [0-9] is supported. But % sure.
On Thu, Oct 30, 2008 at 12:10 PM, Henk Schouten <H.F.Schouten(a)hhs.nl> wrote:
Hello,
I have a simple question, although I could not find the answer in the
archives or google.
Is it possible to use a [0-9] pattern in the where clause of a HQL
query. Something like:
where doc.title like '[0-9]%'
Hope someone can help me with this.
Thanks,
Henk
==
Henk F. Schouten, ICT-architect, Dienst ICT
room: SL 2.32, phone (31) 70 4457611, email: H.F.Schouten(a)hhs.nl
De Haagse Hogeschool, Johanna Westerdijkplein 75, 2521 EN the Hague (NL)
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
--
Thomas Mortagne
5799
days inactive
5800
days old
2 comments
3 participants
participants (3)
-
Henk Schouten -
Sergiu Dumitriu -
Thomas Mortagne