[Erp5-report] r12174 - /erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/Catalo...
nobody at svn.erp5.org
nobody at svn.erp5.org
Sat Jan 20 21:02:55 CET 2007
Author: jp
Date: Sat Jan 20 21:02:52 2007
New Revision: 12174
URL: http://svn.erp5.org?rev=12174&view=rev
Log:
Reverse order of GROUP BY and ORDER BY
Modified:
erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_count_results.xml
erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_search_results.xml
Modified: erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_count_results.xml
URL: http://svn.erp5.org/erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_count_results.xml?rev=12174&r1=12173&r2=12174&view=diff
==============================================================================
--- erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_count_results.xml (original)
+++ erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_count_results.xml Sat Jan 20 21:02:52 2007
@@ -252,15 +252,14 @@
<dtml-if expression> AND <dtml-var expression> </dtml-if>\n
</dtml-let>\n
</dtml-if>\n
+<dtml-if group_by_expression>\n
+GROUP BY\n
+ <dtml-var group_by_expression>\n
+</dtml-if>\n
<dtml-if sort_on>\n
ORDER BY\n
<dtml-var sort_on>\n
</dtml-if>\n
-<dtml-if group_by_expression>\n
-GROUP BY\n
- <dtml-var group_by_expression>\n
-</dtml-if>\n
-
]]></string> </value>
</item>
Modified: erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_search_results.xml
URL: http://svn.erp5.org/erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_search_results.xml?rev=12174&r1=12173&r2=12174&view=diff
==============================================================================
--- erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_search_results.xml (original)
+++ erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_search_results.xml Sat Jan 20 21:02:52 2007
@@ -294,13 +294,13 @@
<dtml-if expression> AND <dtml-var expression> </dtml-if>\n
</dtml-let>\n
</dtml-if>\n
+<dtml-if group_by_expression>\n
+GROUP BY\n
+ <dtml-var group_by_expression>\n
+</dtml-if>\n
<dtml-if sort_on>\n
ORDER BY\n
<dtml-var sort_on>\n
-</dtml-if>\n
-<dtml-if group_by_expression>\n
-GROUP BY\n
- <dtml-var group_by_expression>\n
</dtml-if>\n
<dtml-if limit_expression>\n
LIMIT <dtml-var "limit_expression">\n
More information about the Erp5-report
mailing list