Phalcon\Db::FETCH_COLUMN error: Undefined class constant 'FETCH_COLUMN'

[fizzka]

but #1642 tells us constant must be present.

snippet proposed to be valid:

$result = $db->query($sql, $params);
$result->setFetchMode(Phalcon\Db::FETCH_COLUMN);

$allValuesOfColumn = $result->fetchAll();

little workaround for now:

$result = $db->query($sql, $params);
$allValuesOfColumn = $result->getInternalResult()->fetchAll(PDO::FETCH_COLUMN);

upd: add missed getInternalResult =)

[andresgutierrez]

This is fixed in the 2.0.x branch

[fizzka]

but...

php --ri phalcon

phalcon


Web framework delivered as a C-extension for PHP
phalcon => enabled
Author => Phalcon Team and contributors
Version => 2.0.1
Powered by Zephir => Version 0.6.2a

[andresgutierrez]

2.0.x branch has version 2.0.2

[fizzka]

oh, thanks a lot! waiting for release )

[sergeyklay]

$sql = "SELECT id FROM users LIMIT 1000";

$result = $this->getDI()->get('db')->query($sql);
$result->setFetchMode(\Phalcon\Db::FETCH_COLUMN);
var_dump($result->fetchAll()); // nothing

Error log:

[Exception] SQLSTATE[HY000]: General error: fetch mode requires the colno argument (File: /.../TestTask.php Line: [86])
#0 [internal function]: PDOStatement->setFetchMode(7)
#1 /.../TestTask.php(86): Phalcon\Db\Result\Pdo->setFetchMode(7)

1. What is colno ? MySQL/PHP misspelling?
2. What I do incorrectly?

[sergeyklay]

Possible refs http://forum.phalconphp.com/discussion/2651/how-to-pass-fetch-mode-specific-parameters-

[fizzka]

colno (column number) - it is an additional param from pdo. default value is 0 - first column.