Re: [Tikiwiki-cvs/svn] SF.net SVN: tikiwiki:[22248] trunk/lib/webmail/contactlib.php

[Sylvie G. <sgr...@gm...>]

Following my comments about the quoting after as ... here it is not
quoted.

On Mon, 2009-10-12 at 06:40 +0000, ch...@us... wrote:
> Revision: 22248
>           http://tikiwiki.svn.sourceforge.net/tikiwiki/?rev=22248&view=rev
> Author:   chealer
> Date:     2009-10-12 06:40:52 +0000 (Mon, 12 Oct 2009)
> 
> Log Message:
> -----------
> [FIX] Db abstraction: list_contacts() "ERROR:  column reference "contactId" is ambiguous"
> nyloth: may want to check this
> 
> Modified Paths:
> --------------
>     trunk/lib/webmail/contactlib.php
> 
> Modified: trunk/lib/webmail/contactlib.php
> ===================================================================
> --- trunk/lib/webmail/contactlib.php	2009-10-12 06:37:46 UTC (rev 22247)
> +++ trunk/lib/webmail/contactlib.php	2009-10-12 06:40:52 UTC (rev 22248)
> @@ -31,7 +31,7 @@
>  			array_push($bindvars, $findesc, $findesc, $findesc, $findesc);
>  		}
>  
> -		$query = "select c.* from `tiki_webmail_contacts` as c left join `tiki_webmail_contacts_groups` as a on a.`contactId`=c.`contactId` $mid group by `contactId` order by c.".$this->convertSortMode($sort_mode);
> +		$query = "select distinct c.* from `tiki_webmail_contacts` as c left join `tiki_webmail_contacts_groups` as a on a.`contactId`=c.`contactId` $mid order by c.".$this->convertSortMode($sort_mode);
>  		//$query = "select * from `tiki_webmail_contacts` $mid order by ".$this->convertSortMode($sort_mode);
>  
>  		$result = $this->query($query, $bindvars, $maxRecords, $offset);
> 
> 
> This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
> 
> ------------------------------------------------------------------------------
> Come build with us! The BlackBerry(R) Developer Conference in SF, CA
> is the only developer event you need to attend this year. Jumpstart your
> developing skills, take BlackBerry mobile applications to market and stay 
> ahead of the curve. Join us from November 9 - 12, 2009. Register now!
> http://p.sf.net/sfu/devconference
> _______________________________________________
> Tikiwiki-cvs mailing list
> Tik...@li...
> https://lists.sourceforge.net/lists/listinfo/tikiwiki-cvs