No I speak about this :
http://framework.zend.com/manual/en/zend.db.table.html#zend.db.table.fetchmultiple

$rowset = $table->fetchAll($where, $order, $count, $offset);

it will be good to have a fields parameter :
$rowset = $table->fetchAll($fields, $where, $order, $count, $offset);

Just to not retrieve no needed data :)



On 12/28/06, Bruno Friedmann <[EMAIL PROTECTED]> wrote:

Bill Karwin wrote:
> Yann Nave wrote:
>> Hye everybody.
>>
>> Using ZendFramework 0.6, is there a way to have a rowset object width
>> only some fields ?   Not '*'.
>>
> No, this is not an option in Zend_Db in 0.6.  Currently a
> Zend_Db_Table always fetches all columns reported by a describe of the
> table.
>
> I've added your question as a feature request to our JIRA issue
> tracker, and it will be evaluated later.
> http://framework.zend.com/issues/browse/ZF-694
>
> Regards,
> Bill Karwin
>

Hi Bill,

Would you say that code like this one

        $select = $this->_db->select();
        $select->from($this->_tpanier.' as t1', 't1.pnum')
                ->join($this->_tpdetails.' as t2', 't2.pnum = t1.pnum',
array('t2.id','t2.article', 't2.quantite'))
                ->join('t_catalogue_'.$this->_lang.' as t3' , 't3.CODMOD
= t2.article', array('t3.TITLE','t3.PRIX'))
                ->where('t1.pnum = ?', $pnum);
        try {
            $this->ddetails = $this->_db->fetchAll($select);
        } catch (Zend_Db_Exception $e) {
            echo '<h6> Getting basket goes wrong ! </h6>'."\n";
            echo $e->getMessage();
            return false;
        }

Wouldn't work on 0.6 ?
I'm using it on 0.2 and it work so nice ...



--

        Bruno Friedmann <[EMAIL PROTECTED]>

Ioda-Net Sàrl
        c/o RFV, H. Vauclair SA
        Rue de l'Avenir 12
        2800 Delémont - Switzerland
        Tél : ++41 32 435 7171
        Fax : ++41 32 435 7172
        gsm : ++41 78 802 6760
www.ioda-net.ch         Solutions informatiques et internet, coaching et
relooking
www.cfcel.com           Centre de formation et de coaching en ligne





--
Yannux
http://blog.onbebop.net

Reply via email to