Changeset 2816 for trunk/www/requirements/mura/extend

Timestamp:

09/09/10 19:14:27 (21 months ago)

Author:

mattlevine

Message:

1. Adding setAllValues and getAllValues to the rateBean.
2. Changing extendObjectFeedBean.getQUery() from group by to select distinct

Location:

trunk/www/requirements/mura/extend

Files:

• . (modified) (1 prop)
• extendObjectFeedBean.cfc (modified) (3 diffs)

trunk/www/requirements/mura/extend/extendObjectFeedBean.cfc

@@ -251 +251 @@
         <cfquery name="rs" datasource="#variables.configBean.getDatasource()#" blockfactor="#blockFactor#"  username="#variables.configBean.getDBUsername()#" password="#variables.configBean.getDBPassword()#">
         <cfif dbType eq "oracle" and getMaxItems()>select * from (</cfif>
-        select  <cfif dbtype eq "mssql" and getMaxItems()>top #getMaxItems()#</cfif>    
+        select distinct <cfif dbtype eq "mssql" and getMaxItems()>top #getMaxItems()#</cfif>    
         tclassextend.type,tclassextend.subtype,tclassextend.siteID, #dataTable#.baseID as ID
         from #dataTable#
@@ -271 +271 @@
         on (#dataTable#.baseID=qExtendedSort.baseID)
         </cfif>
-
         
         where
@@ -335 +334 @@
                 <cfif started>)</cfif>
         </cfif>
-
-        group by tclassextend.type,tclassextend.subtype,tclassextend.siteID,#dataTable#.baseID
         
         <cfif len(getSortBy())>