[geeklog-cvs] geeklog: Fixed SQL compatibility with MS SQL (bug #0001050)

[geeklog-cvs at lists.geeklog.net]

changeset 7564:c704921e03c8
url:  http://project.geeklog.net/cgi-bin/hgwebdir.cgi/geeklog/rev/c704921e03c8
user: Dirk Haun <dirk at haun-online.de>
date: Thu Dec 31 15:17:54 2009 +0100
description:
Fixed SQL compatibility with MS SQL (bug #0001050)

diffstat:

 plugins/staticpages/functions.inc |  2 +-
 public_html/docs/history          |  1 +
 2 files changed, 2 insertions(+), 1 deletions(-)

diffs (23 lines):

diff -r 9836fc7dcc23 -r c704921e03c8 plugins/staticpages/functions.inc
--- a/plugins/staticpages/functions.inc	Thu Dec 31 11:15:16 2009 +0100
+++ b/plugins/staticpages/functions.inc	Thu Dec 31 15:17:54 2009 +0100
@@ -1505,7 +1505,7 @@
     
     $sql = "SELECT sp_id, sp_title 
         FROM {$_TABLES['staticpage']} 
-        WHERE NOT ISNULL(sp_content) AND (draft_flag = 0) AND (sp_date >= (DATE_SUB(NOW(), INTERVAL {$_SP_CONF['newstaticpagesinterval']} SECOND))) 
+        WHERE sp_content IS NOT NULL AND (draft_flag = 0) AND (sp_date >= (DATE_SUB(NOW(), INTERVAL {$_SP_CONF['newstaticpagesinterval']} SECOND))) 
         {$extra_sql} 
         " . COM_getPermSQL('AND') . " 
         ORDER BY sp_date DESC LIMIT 15";
diff -r 9836fc7dcc23 -r c704921e03c8 public_html/docs/history
--- a/public_html/docs/history	Thu Dec 31 11:15:16 2009 +0100
+++ b/public_html/docs/history	Thu Dec 31 15:17:54 2009 +0100
@@ -34,6 +34,7 @@
 
 Static Pages Plugin 1.6.2
 -------------------
+- Fixed SQL compatibility with MS SQL (bug #0001050)
 - Added a draft flag (feature request #0000884) [Dirk]
 - Removed the sp_uid field since it's simply a duplicate of owner_id [Dirk]
 - Display number of comments in Static Page editor [Dirk]