Changeset 6652 for trunk/include/ws_functions.inc.php

Timestamp:

Jul 3, 2010, 2:12:25 PM (14 years ago)

Author:

nikrou

Message:

Bug 1754 fixed : The keyword AS is mandatory for alias in PostgreSQL queries

File:

• trunk/include/ws_functions.inc.php (modified) (3 diffs)

trunk/include/ws_functions.inc.php

@@ -286 +286 @@
 
     $query = '
-SELECT i.*, GROUP_CONCAT(category_id) cat_ids
+SELECT i.*, GROUP_CONCAT(category_id) AS cat_ids
   FROM '.IMAGES_TABLE.' i
     INNER JOIN '.IMAGE_CATEGORY_TABLE.' ON i.id=image_id
@@ -694 +694 @@
 
   $query = '
-SELECT COUNT(id) nb_comments
+SELECT COUNT(id) AS nb_comments
   FROM '.COMMENTS_TABLE.'
   WHERE '.$where_comments;
@@ -1455 +1455 @@
     {
       $query = '
-SELECT image_id, GROUP_CONCAT(tag_id) tag_ids
+SELECT image_id, GROUP_CONCAT(tag_id) AS tag_ids
   FROM '.IMAGE_TAG_TABLE.'
   WHERE tag_id IN ('.implode(',',$tag_ids).')