{"action":"created","issue":{"url":"https://api.github.com/repos/phalcon/cphalcon/issues/3191","labels_url":"https://api.github.com/repos/phalcon/cphalcon/issues/3191/labels{/name}","comments_url":"https://api.github.com/repos/phalcon/cphalcon/issues/3191/comments","events_url":"https://api.github.com/repos/phalcon/cphalcon/issues/3191/events","html_url":"https://github.com/phalcon/cphalcon/issues/3191","id":53645228,"number":3191,"title":"fetch mode specific parameters ","user":{"login":"salarmehr","id":2582036,"avatar_url":"https://avatars.githubusercontent.com/u/2582036?v=3","gravatar_id":"","url":"https://api.github.com/users/salarmehr","html_url":"https://github.com/salarmehr","followers_url":"https://api.github.com/users/salarmehr/followers","following_url":"https://api.github.com/users/salarmehr/following{/other_user}","gists_url":"https://api.github.com/users/salarmehr/gists{/gist_id}","starred_url":"https://api.github.com/users/salarmehr/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/salarmehr/subscriptions","organizations_url":"https://api.github.com/users/salarmehr/orgs","repos_url":"https://api.github.com/users/salarmehr/repos","events_url":"https://api.github.com/users/salarmehr/events{/privacy}","received_events_url":"https://api.github.com/users/salarmehr/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":5,"created_at":"2015-01-07T15:41:43Z","updated_at":"2015-04-24T02:53:04Z","closed_at":null,"body":"How should I pass each fetch mode specific parameters (http://php.net/manual/en/pdostatement.setfetchmode.php) in the following statement. Here I need to pass the colno parameter.\r\n\r\n```\r\n$this->di['db']->fetchOne('select role from user', Phalcon\\Db::FETCH_COLUMN,[]);\r\n```\r\nCurrently I get this error: SQLSTATE[HY000]: General error: fetch mode requires the colno argument\r\n\r\n<bountysource-plugin>\r\n---\r\nWant to back this issue? **[Post a bounty on it!](https://www.bountysource.com/issues/7563065-fetch-mode-specific-parameters?utm_campaign=plugin&utm_content=tracker%2F50707&utm_medium=issues&utm_source=github)** We accept bounties via [Bountysource](https://www.bountysource.com/?utm_campaign=plugin&utm_content=tracker%2F50707&utm_medium=issues&utm_source=github).\r\n</bountysource-plugin>"},"comment":{"url":"https://api.github.com/repos/phalcon/cphalcon/issues/comments/95781938","html_url":"https://github.com/phalcon/cphalcon/issues/3191#issuecomment-95781938","issue_url":"https://api.github.com/repos/phalcon/cphalcon/issues/3191","id":95781938,"user":{"login":"salarmehr","id":2582036,"avatar_url":"https://avatars.githubusercontent.com/u/2582036?v=3","gravatar_id":"","url":"https://api.github.com/users/salarmehr","html_url":"https://github.com/salarmehr","followers_url":"https://api.github.com/users/salarmehr/followers","following_url":"https://api.github.com/users/salarmehr/following{/other_user}","gists_url":"https://api.github.com/users/salarmehr/gists{/gist_id}","starred_url":"https://api.github.com/users/salarmehr/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/salarmehr/subscriptions","organizations_url":"https://api.github.com/users/salarmehr/orgs","repos_url":"https://api.github.com/users/salarmehr/repos","events_url":"https://api.github.com/users/salarmehr/events{/privacy}","received_events_url":"https://api.github.com/users/salarmehr/received_events","type":"User","site_admin":false},"created_at":"2015-04-24T02:53:04Z","updated_at":"2015-04-24T02:53:04Z","body":"@olivier-monaco Actually, I want use `FETCH_COLUMN` because it returns an array instead of a resource. "}}