[eluser]gtech[/eluser]
you don't pass a parameter like that into distinct..
this is the function in the active record code
Code:
function distinct($val = TRUE)
{
$this->ar_distinct = (is_bool($val)) ? $val : TRUE;
return $this;
}
when it runs the sql statement it uses the following line of code
Code:
$sql = ( ! $this->ar_distinct) ? 'SELECT ' : 'SELECT DISTINCT ';
so distinct only takes TRUE or FALSE as a parameter, and the default is TRUE if nothing is passed in.
hope this helps you.