Author: keith
Date: Mon May 5 05:02:27 2008
New Revision: 16532
Log:
Fixing Mashup-785
Modified:
trunk/mashup/java/modules/core/src/org/wso2/mashup/RegistryInitializer.java
Modified:
trunk/mashup/java/modules/core/src/org/wso2/mashup/RegistryInitializer.java
==============================================================================
--- trunk/mashup/java/modules/core/src/org/wso2/mashup/RegistryInitializer.java
(original)
+++ trunk/mashup/java/modules/core/src/org/wso2/mashup/RegistryInitializer.java
Mon May 5 05:02:27 2008
@@ -446,7 +446,7 @@
addQuery(
systemRegistry,
MashupConstants.COMMENTS_QUERY_PATH,
- "SELECT C.CM_ID FROM COMMENT C, RESOURCE A WHERE
C.COMMENT_TEXT " +
+ "SELECT C.COMMENT_ID FROM COMMENT C, RESOURCE A WHERE
C.COMMENT_TEXT " +
"LIKE ? AND C.RID=A.RID AND (A.MEDIA_TYPE='" +
MashupConstants.MASHUP_MEDIA_TYPE +
"' OR A.MEDIA_TYPE='wso2_data_service')",
@@ -457,7 +457,7 @@
addQuery(
systemRegistry,
MashupConstants.MY_COMMENTS_QUERY_PATH,
- "SELECT C.CM_ID FROM COMMENT C, RESOURCE A WHERE
C.COMMENT_TEXT " +
+ "SELECT C.COMMENT_ID FROM COMMENT C, RESOURCE A WHERE
C.COMMENT_TEXT " +
"LIKE ? AND C.USER_ID=? AND C.RID=A.RID AND " +
"(A.MEDIA_TYPE='" + MashupConstants.MASHUP_MEDIA_TYPE +
"' OR A.MEDIA_TYPE='wso2_data_service')",
@@ -468,7 +468,7 @@
addQuery(
systemRegistry,
MashupConstants.USERS_COMMENTS_QUERY_PATH,
- "SELECT C.CM_ID FROM COMMENT C, RESOURCE A WHERE C.USER_ID=?
AND " +
+ "SELECT C.COMMENT_ID FROM COMMENT C, RESOURCE A WHERE
C.USER_ID=? AND " +
"C.RID=A.RID AND AND (A.MEDIA_TYPE='" +
MashupConstants.MASHUP_MEDIA_TYPE +
"' OR A.MEDIA_TYPE='wso2_data_service')",
_______________________________________________
Mashup-dev mailing list
[email protected]
http://www.wso2.org/cgi-bin/mailman/listinfo/mashup-dev
