ZF-2597: Possibility to choose column in fetchCol

Issue Type: Improvement Created: 2008-02-07T04:14:42.000+0000 Last Updated: 2009-01-10T11:11:41.000+0000 Status: Closed Fix version(s): - 1.8.0 (30/Apr/09)

Reporter: Kamil Nowakowski (kamiln) Assignee: Ralph Schindler (ralph) Tags: - Zend_Db

Related issues: Attachments:


Add possibility to choose column in function fetchCol I would like to choose for example index 3 or 'name' now it allways select first column

<pre class="highlight">
$connection->fetchCol($sql, $bind , $index);


Posted by Martin Hujer (mhujer) on 2008-02-07T05:35:40.000+0000

I think, that fetchCol() is intended for sql queries like this:

<pre class="highlight">
SELECT nickname FROM Users;

Defined column is not good way to do this, you should optimize your queries to select just column you need.

Posted by Wil Sinclair (wil) on 2008-03-25T20:43:52.000+0000

Please categorize/fix as needed.

Posted by Wil Sinclair (wil) on 2008-04-18T13:11:50.000+0000

This doesn't appear to have been fixed in 1.5.0. Please update if this is not correct.

Posted by Wil Sinclair (wil) on 2008-12-04T12:53:16.000+0000

Reassigning as Ralph is the maintainer of Zend_Db

Posted by Ralph Schindler (ralph) on 2009-01-10T11:11:41.000+0000

As noted in the comments, there is an easy way to accomplish this.

Have you found an issue?

See the Overview section for more details.


© 2006-2018 by Zend, a Rogue Wave Company. Made with by awesome contributors.

This website is built using zend-expressive and it runs on PHP 7.