[Erp5-report] r31140 kazuhiko - in /erp5/trunk/bt5/erp5_calendar: SkinTemplateItem/portal_s...

[nobody at svn.erp5.org]

Author: kazuhiko
Date: Tue Dec  8 10:16:09 2009
New Revision: 31140

URL: http://svn.erp5.org?rev=31140&view=rev
Log:
CAST to num explicitly otherwise it may be treated as binary in MySQL-5.0.x.

Modified:
    erp5/trunk/bt5/erp5_calendar/SkinTemplateItem/portal_skins/erp5_calendar/Person_zGetAvailableTime.xml
    erp5/trunk/bt5/erp5_calendar/bt/revision

Modified: erp5/trunk/bt5/erp5_calendar/SkinTemplateItem/portal_skins/erp5_calendar/Person_zGetAvailableTime.xml
URL: http://svn.erp5.org/erp5/trunk/bt5/erp5_calendar/SkinTemplateItem/portal_skins/erp5_calendar/Person_zGetAvailableTime.xml?rev=31140&r1=31139&r2=31140&view=diff
==============================================================================
--- erp5/trunk/bt5/erp5_calendar/SkinTemplateItem/portal_skins/erp5_calendar/Person_zGetAvailableTime.xml [utf8] (original)
+++ erp5/trunk/bt5/erp5_calendar/SkinTemplateItem/portal_skins/erp5_calendar/Person_zGetAvailableTime.xml [utf8] Tue Dec  8 10:16:09 2009
@@ -198,7 +198,8 @@
   CASE WHEN @result < 0 THEN\n
     0\n
   ELSE\n
-    @result\n
+    <dtml-comment>CAST to num explicitly otherwise it may be treated as binary in MySQL-5.0.x</dtml-comment>\n
+    0 + @result\n
   END AS total_quantity,\n
 \n
   <dtml-sqlvar expr="from_date" type="datetime"> AS from_date,\n
@@ -345,7 +346,8 @@
   CASE WHEN @result < 0 THEN\n
     0\n
   ELSE\n
-    @result\n
+    <dtml-comment>CAST to num explicitly otherwise it may be treated as binary in MySQL-5.0.x</dtml-comment>\n
+    0 + @result\n
   END AS total_quantity,\n
 \n
   <dtml-sqlvar expr="from_date" type="datetime"> AS from_date,\n

Modified: erp5/trunk/bt5/erp5_calendar/bt/revision
URL: http://svn.erp5.org/erp5/trunk/bt5/erp5_calendar/bt/revision?rev=31140&r1=31139&r2=31140&view=diff
==============================================================================
--- erp5/trunk/bt5/erp5_calendar/bt/revision [utf8] (original)
+++ erp5/trunk/bt5/erp5_calendar/bt/revision [utf8] Tue Dec  8 10:16:09 2009
@@ -1,1 +1,1 @@
-353
+354