Author: keith
Date: Mon May  5 04:52:41 2008
New Revision: 16530

Log:

Fixing Mashup-786

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 04:52:41 2008
@@ -384,7 +384,7 @@
                 systemRegistry,
                 MashupConstants.TOP_MASHUPS_QUERY_PATH,
                 "SELECT A.PATH FROM RESOURCE A, RATING R WHERE " +
-                        "A.AID=R.AID AND (A.MEDIA_TYPE='" +
+                        "A.RID=R.RID AND (A.MEDIA_TYPE='" +
                         MashupConstants.MASHUP_MEDIA_TYPE + "' OR " +
                         "A.MEDIA_TYPE='wso2_data_service') GROUP BY A.PATH 
HAVING " +
                         "AVG(R.RATING) >= 4.0 ORDER BY AVG(R.RATING) DESC",

_______________________________________________
Mashup-dev mailing list
[email protected]
http://www.wso2.org/cgi-bin/mailman/listinfo/mashup-dev

Reply via email to