Changeset 2813 for branches/5.2/www/requirements/mura/extend

Timestamp:

09/09/10 17:07:26 (21 months ago)

Author:

mattlevine

Message:

1. Changing from group by to select distinct

File:

• branches/5.2/www/requirements/mura/extend/extendObjectFeedBean.cfc (modified) (3 diffs)

branches/5.2/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())>