Update of
/var/cvs/contributions/CMSContainer_Portlets/portlets-tagcloud/src/java/com/finalist/portlets/tagcloud/util
In directory
james.mmbase.org:/tmp/cvs-serv16107/portlets-tagcloud/src/java/com/finalist/portlets/tagcloud/util
Modified Files:
TagCloudUtil.java
Log Message:
CMSC-1066 Fix voor probleem met queries
See also:
http://cvs.mmbase.org/viewcvs/contributions/CMSContainer_Portlets/portlets-tagcloud/src/java/com/finalist/portlets/tagcloud/util
See also: http://www.mmbase.org/jira/browse/CMSC-1066
Index: TagCloudUtil.java
===================================================================
RCS file:
/var/cvs/contributions/CMSContainer_Portlets/portlets-tagcloud/src/java/com/finalist/portlets/tagcloud/util/TagCloudUtil.java,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -b -r1.5 -r1.6
--- TagCloudUtil.java 14 Oct 2008 12:31:08 -0000 1.5
+++ TagCloudUtil.java 20 Oct 2008 15:55:28 -0000 1.6
@@ -69,14 +69,14 @@
"FROM mm_tag source_tag,mm_insrel
source_insrel,mm_contentelement contentelement, mm_insrel target_insrel, mm_tag
target_tag "+
"WHERE source_tag.number=source_insrel.dnumber AND
contentelement.number=source_insrel.snumber "+
"AND target_tag.number=target_insrel.dnumber AND
contentelement.number=target_insrel.snumber "+
- "AND LOWER(source_tag.name) = 'TAG_NAME' AND tag.name is not
null "+
+ "AND LOWER(source_tag.name) = 'TAG_NAME' "+
"GROUP BY target_tag.name,target_tag.description ";
private static final String SQL_LIVE_SELECT_TAG_RELATED_TAGS = "SELECT
target_tag.number,target_tag.name,target_tag.description,COUNT(contentelement.number)
AS cnt "+
"FROM live_tag source_tag,live_insrel
source_insrel,live_contentelement contentelement, live_insrel target_insrel,
live_tag target_tag "+
"WHERE source_tag.number=source_insrel.dnumber AND
contentelement.number=source_insrel.snumber "+
"AND target_tag.number=target_insrel.dnumber AND
contentelement.number=target_insrel.snumber "+
- "AND LOWER(source_tag.name) = 'TAG_NAME' AND tag.name is not
null "+
+ "AND LOWER(source_tag.name) = 'TAG_NAME' "+
"GROUP BY target_tag.name,target_tag.description ";
private static Connection getConnection() {
_______________________________________________
Cvs mailing list
[email protected]
http://lists.mmbase.org/mailman/listinfo/cvs
