[OpenbravoERP-commits] erp/devel/pageddatagrid: 2 new changesets

[hg]

details:   /erp/erp/devel/pageddatagrid/rev/5e0107243d2a
changeset: 4828:5e0107243d2a
user:      Stefan Hühner <stefan.huehner <at> openbravo.com>
date:      Thu Aug 27 22:11:16 2009 +0200
summary:   [PagedGrid] Fixed select to avoid ambigous column definition error 
on oracle

details:   /erp/erp/devel/pageddatagrid/rev/e156dd96e5b8
changeset: 4829:e156dd96e5b8
user:      Stefan Hühner <stefan.huehner <at> openbravo.com>
date:      Thu Aug 27 22:12:11 2009 +0200
summary:   [PagedGrid] Fix type on javascript leading to read of undefined var

diffstat:

 src-wad/src/org/openbravo/wad/controls/WADGrid.java   |  2 +-
 src/org/openbravo/erpCommon/info/Product_data.xsql    |  2 +-
 src/org/openbravo/erpCommon/utility/TableSQLData.java |  2 +-
 3 files changed, 3 insertions(+), 3 deletions(-)

diffs (36 lines):

diff -r 9b2921161334 -r e156dd96e5b8 
src-wad/src/org/openbravo/wad/controls/WADGrid.java
--- a/src-wad/src/org/openbravo/wad/controls/WADGrid.java       Tue Aug 25 
18:06:35 2009 +0200
+++ b/src-wad/src/org/openbravo/wad/controls/WADGrid.java       Thu Aug 27 
22:12:11 2009 +0200
@@ -62,7 +62,7 @@
         + "  var strPrevious = getMessage(\"GridPreviousPage\");\n"
         + "  var strNext = getMessage(\"GridNextPage\");\n"
         + "\n"
-        + "  if (!firstPage || fullPage) {\n"
+        + "  if (!firstPage || pageFull) {\n"
         + "    res = res + \"<span>&nbsp;&nbsp;&nbsp;</span>\";\n"
         + "  }\n"
         + "  if (!firstPage) {\n"
diff -r 9b2921161334 -r e156dd96e5b8 
src/org/openbravo/erpCommon/info/Product_data.xsql
--- a/src/org/openbravo/erpCommon/info/Product_data.xsql        Tue Aug 25 
18:06:35 2009 +0200
+++ b/src/org/openbravo/erpCommon/info/Product_data.xsql        Thu Aug 27 
22:12:11 2009 +0200
@@ -88,7 +88,7 @@
       <SqlMethodComment></SqlMethodComment>
       <Sql> <![CDATA[
       SELECT count(*) AS value FROM ( SELECT '0' AS rn1, B.*  FROM ( 
-        SELECT * FROM M_Product p, M_ProductPrice pr
+        SELECT 1 FROM M_Product p, M_ProductPrice pr
         WHERE p.M_Product_ID=pr.M_Product_ID 
         AND p.IsSummary='N' 
         AND p.IsActive='Y' 
diff -r 9b2921161334 -r e156dd96e5b8 
src/org/openbravo/erpCommon/utility/TableSQLData.java
--- a/src/org/openbravo/erpCommon/utility/TableSQLData.java     Tue Aug 25 
18:06:35 2009 +0200
+++ b/src/org/openbravo/erpCommon/utility/TableSQLData.java     Thu Aug 27 
22:12:11 2009 +0200
@@ -2533,7 +2533,7 @@
     } else {
     }
 
-    text.append("SELECT * ");
+    text.append("SELECT 1 ");
 
     aux = getFromFields();
     if (aux != null) {

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Openbravo-commits mailing list
Openbravo-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-commits