partkeepr

commit 73868d751fa4154967e8068d68bf0d39f8e71d5e
parent 61430195e93bdc6628d20ed189d665538d365fb5
Author: Felicitus <felicitus@felicitus.org>
Date:   Sun,  1 Jan 2012 12:09:39 +0100

Workarounds for DBAL with PostgreSQL

Diffstat:
M
src/backend/de/RaumZeitLabor/PartKeepr/SystemNotice/SystemNoticeManager.php
 | 
2
+-
M
src/backend/de/RaumZeitLabor/PartKeepr/SystemNotice/SystemNoticeService.php
 | 
4
++--

2 files changed, 3 insertions(+), 3 deletions(-)
diff --git a/src/backend/de/RaumZeitLabor/PartKeepr/SystemNotice/SystemNoticeManager.php b/src/backend/de/RaumZeitLabor/PartKeepr/SystemNotice/SystemNoticeManager.php
@@ -36,7 +36,7 @@ class SystemNoticeManager extends AbstractManager {
 		$dql = "SELECT sn FROM de\RaumZeitLabor\PartKeepr\SystemNotice\SystemNotice sn WHERE sn.type = :type";
 		$query = PartKeepr::getEM()->createQuery($dql);
 		
-		$query->setParameter("type", $type);
+		$query->setParameter("type", $type, \PDO::PARAM_BOOL);
 		
 		try {
 			$notice = $query->getSingleResult();
diff --git a/src/backend/de/RaumZeitLabor/PartKeepr/SystemNotice/SystemNoticeService.php b/src/backend/de/RaumZeitLabor/PartKeepr/SystemNotice/SystemNoticeService.php
@@ -26,7 +26,7 @@ class SystemNoticeService extends Service implements RestfulService {
 	
 	public function filterCallback ($queryBuilder) {
 		$queryBuilder->andWhere("q.acknowledged = :acknowledged");
-		$queryBuilder->setParameter("acknowledged", false);
+		$queryBuilder->setParameter("acknowledged", false, \PDO::PARAM_BOOL);
 	}
 	/**
 	 * Stub method to fulfill the RestfulService. We don't want to have SystemNotices created by the user, so
@@ -73,7 +73,7 @@ class SystemNoticeService extends Service implements RestfulService {
 	public function hasUnacknowledgedNotices () {
 		$dql = "SELECT COUNT(c) FROM de\RaumZeitLabor\PartKeepr\SystemNotice\SystemNotice c WHERE c.acknowledged = :a";
 		$query = PartKeepr::getEM()->createQuery($dql);
-		$query->setParameter("a", false);
+		$query->setParameter("a", false, \PDO::PARAM_BOOL);
 		
 		$bRetval = false;