[Sciret-svn] SF.net SVN: sciret:[657] trunk/models/ArticleGateway.php

[<al...@us...>]

Revision: 657
          http://sciret.svn.sourceforge.net/sciret/?rev=657&view=rev
Author:   alpeb
Date:     2008-08-28 20:46:48 +0000 (Thu, 28 Aug 2008)

Log Message:
-----------
fixed bad query

Modified Paths:
--------------
    trunk/models/ArticleGateway.php

Modified: trunk/models/ArticleGateway.php
===================================================================
--- trunk/models/ArticleGateway.php	2008-08-28 20:45:04 UTC (rev 656)
+++ trunk/models/ArticleGateway.php	2008-08-28 20:46:48 UTC (rev 657)
@@ -87,7 +87,7 @@
                 break;
             case 'withFullName':
                 $query = 'SELECT SQL_CALC_FOUND_ROWS art.art_id, is_bookmark, q_id, title, url, expires, question, SUBSTRING(content, 1, '.EXCERPT_LENGTH.') AS excerpt, cat_id, published, draft, art.user_id, views, created, modified, modified_user_id, votes_1, votes_2, votes_3, votes_4, votes_5, firstname, lastname '
-                        .'FROM articles art LEFT JOIN users u ON art.user_id = u.id'
+                        .'FROM articles art LEFT JOIN users u ON art.user_id = u.id '
                         . $where . " ORDER BY $order $direction";
                 if ($numRecords != -1) {
                     $query .= ' LIMIT ' . (int)$offset . ', ' . (int)$numRecords;


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.