JCR SQL Queries

5 02 2009

Care needs to be taken

SELECT *  FROM nt:base  WHERE jcr:path LIKE '/userenv/%'

works, but

SELECT *  FROM nt:base  WHERE jcr:path LIKE '/userenv%'

does not.

About these ads

Actions

Information

2 responses

5 02 2009
Glenn Golden

Why does the second query not work?

5 02 2009
Ian Boston

No idea :), remember is a JSR-170 SQL query, not a RDBMS SQL query.




Follow

Get every new post delivered to your Inbox.

Join 121 other followers

%d bloggers like this: