1.1 --- a/plugins/staticpages/services.inc.php	Tue Aug 04 09:23:31 2009 -0400
     1.2 +++ b/plugins/staticpages/services.inc.php	Sat Oct 03 21:15:34 2009 +0200
     1.3 @@ -563,15 +563,18 @@
     1.4          }
     1.5          $sql = array();
     1.6          $sql['mysql'] = "SELECT sp_title,sp_content,sp_hits,sp_date,sp_format,"
     1.7 -                      . "commentcode,meta_description,meta_keywords,owner_id,group_id,perm_owner,perm_group,"
     1.8 +                      . "commentcode,meta_description,meta_keywords,owner_id,"
     1.9 +                      . "group_id,perm_owner,perm_group,"
    1.10                        . "perm_members,perm_anon,sp_tid,sp_help,sp_php,"
    1.11                        . "sp_inblock FROM {$_TABLES['staticpage']} "
    1.12                        . "WHERE (sp_id = '$page')" . $perms;
    1.13          $sql['mssql'] = "SELECT sp_title,"
    1.14                        . "CAST(sp_content AS text) AS sp_content,sp_hits,"
    1.15 -                      . "sp_date,sp_format,commentcode,owner_id,group_id,"
    1.16 -                      . "perm_owner,perm_group,perm_members,perm_anon,sp_tid,"
    1.17 -                      . "sp_help,sp_php,sp_inblock "
    1.18 +                      . "sp_date,sp_format,commentcode,"
    1.19 +                      . "CAST(meta_description AS text) AS meta_description,"
    1.20 +                      . "CAST(meta_keywords AS text) AS meta_keywords,"
    1.21 +                      . "owner_id,group_id,perm_owner,perm_group,perm_members,"
    1.22 +                      . "perm_anon,sp_tid,sp_help,sp_php,sp_inblock "
    1.23                        . "FROM {$_TABLES['staticpage']} WHERE (sp_id = '$page')"
    1.24                        . $perms;
    1.25          $result = DB_query ($sql);