Author: ndkhoiits
Date: 2010-09-08 06:59:10 -0400 (Wed, 08 Sep 2010)
New Revision: 4088
Modified:
portal/branches/branch-r4047/component/portal/src/main/java/org/exoplatform/portal/pom/config/POMSession.java
Log:
Indicate slash symbol when using LIKE syntax to search special characters
Modified:
portal/branches/branch-r4047/component/portal/src/main/java/org/exoplatform/portal/pom/config/POMSession.java
===================================================================
---
portal/branches/branch-r4047/component/portal/src/main/java/org/exoplatform/portal/pom/config/POMSession.java 2010-09-08
10:51:20 UTC (rev 4087)
+++
portal/branches/branch-r4047/component/portal/src/main/java/org/exoplatform/portal/pom/config/POMSession.java 2010-09-08
10:59:10 UTC (rev 4088)
@@ -314,7 +314,7 @@
"jcr:path LIKE '" + workspaceChunk + "/" +
ownerTypeChunk + "/" + ownerIdChunk
+ "/mop:rootpage/mop:children/mop:pages/mop:children/%' AND
" +
"(" +
- "LOWER(gtn:name) LIKE '%" + title.toLowerCase() +
"%')";
+ "LOWER(gtn:name) LIKE '%" + title.toLowerCase() +
"%' ESCAPE '\\')";
}
else
{
Show replies by date