[prev in list] [next in list] [prev in thread] [next in thread] 

List:       bricolage-commits
Subject:    [6112] Quote boolean parameters.
From:       theory () bricolage ! cc
Date:       2004-12-26 20:13:30
Message-ID: 20041226201330.4973.qmail () x1 ! develooper ! com
[Download RAW message or body]

Revision: 6112
Author:   theory
Date:     2004-12-26 12:13:29 -0800 (Sun, 26 Dec 2004)
ViewCVS:  http://viewsvn.bricolage.cc/?rev=6112&view=rev

Log Message:
-----------
Quote boolean parameters.

Modified Files:
--------------
    bricolage/trunk/lib/Bric/Biz/Asset/Business/Story.pm



["r6112-theory.diff" (r6112-theory.diff)]

Modified: bricolage/trunk/lib/Bric/Biz/Asset/Business/Story.pm
===================================================================
--- bricolage/trunk/lib/Bric/Biz/Asset/Business/Story.pm	2004-12-26 20:11:59 UTC (rev 6111)
+++ bricolage/trunk/lib/Bric/Biz/Asset/Business/Story.pm	2004-12-26 20:13:29 UTC (rev 6112)
@@ -351,7 +351,7 @@
       _not_checked_out       => 'i.checked_out = 0 AND s.id not in '
                               . '(SELECT story__id FROM story_instance '
                               . 'WHERE s.id = story_instance.story__id '
-                              . 'AND story_instance.checked_out = 1)',
+                              . "AND story_instance.checked_out = '1')",
       primary_oc_id          => 'i.primary_oc__id = ?',
       output_channel_id      => '(i.id = soc.story_instance__id AND '
                               . '(soc.output_channel__id = ? OR '
@@ -359,7 +359,7 @@
       category_id            => 'i.id = sc2.story_instance__id AND '
                               . 'sc2.category__id = ?',
       primary_category_id    => 'i.id = sc2.story_instance__id AND '
-                              . 'sc2.category__id = ? AND sc2.main = 1',
+                              . "sc2.category__id = ? AND sc2.main = '1'",
       category_uri           => 'i.id = sc2.story_instance__id AND '
                               . 'sc2.category__id = c.id AND '
                               . 'LOWER(c.uri) LIKE LOWER(?)',
@@ -409,13 +409,13 @@
                                 'i.primary_oc__id = ?' ],
     category_id            => [ 'i.id = sc2.story_instance__id',
                                 'sc2.category__id = ?' ],
-    primary_category_id    => [ 'i.id = sc2.story_instance__id AND sc2.main = 1',
+    primary_category_id    => [ "i.id = sc2.story_instance__id AND sc2.main = '1'",
                                 'sc2.category__id = ?' ],
     category_uri           => [ 'i.id = sc2.story_instance__id AND sc2.category__id = c.id',
                                 'LOWER(c.uri) LIKE LOWER(?)' ],
     keyword                => [ 'sk.story_id = s.id AND k.id = sk.keyword_id',
                                 'LOWER(k.name) LIKE LOWER(?)' ],
-    grp_id                 => [ 'm2.active = 1 AND sm2.member__id = m2.id AND s.id = sm2.object_id',
+    grp_id                 => [ "m2.active = '1' AND sm2.member__id = m2.id AND s.id = sm2.object_id",
                                 'm2.grp__id = ?' ],
     contrib_id             => [ 'i.id = sic.story_instance__id',
                                 'sic.member__id = ?' ],


[prev in list] [next in list] [prev in thread] [next in thread]