Welcome Guest, Not a member yet? Register   Sign In
DB select 'feature'/'bug'
#1

[eluser]Unknown[/eluser]
Code:
$this->db->select(
    'this,
     that,
     -- theother,
     something
)->get('table');

reformats my select statment triming all the lines into a single line for the select part which makes '-- the other, something' commented out. I only wanted theother commented out.

offending code in system/database/DB_active_rec.php:

Code:
/**
     * Select
     *
     * Generates the SELECT portion of the query
     *
     * @access    public
     * @param    string
     * @return    object
     */
    function select($select = '*')
    {
        if (is_string($select))
        {
            $select = explode(',', $select);
        }
    
        foreach ($select as $val)
        {
            $val = trim($val);
        
            if ($val != '')
                $this->ar_select[] = $val;
        }
        return $this;
    }

what's the premise of doing it this way?

Thanks,
Jordan
#2

[eluser]champs[/eluser]
I don't think the user guide says so, but... active record supports multiple select statements.
Code:
<?php
$this->db->select('this, that');
$this->db->select('theother, something');
?>




Theme © iAndrew 2016 - Forum software by © MyBB