Cakephp use numeric values with quote as string is not working

Question

I want generate following query.

SELECT `Scale`.`id`, `Scale`.`name` 
FROM `woa`.`scales` AS `Scale` 
WHERE `Scale`.`enabled` = '1'

So i wrote following lines in cackphp controller.

$this->set('scales', $this->Scale->find('list', array(
    'conditions' => array('Scale.enabled' => '1')
)));

But it generate following query with out quotation in Scale.enabled value.

SELECT `Scale`.`id`, `Scale`.`name` 
FROM `woa`.`scales` AS `Scale` 
WHERE `Scale`.`enabled` = 1

How can i use quotations with numeric (bt actually it is string) value?

what's wrong with the executed sql? What error does it trigger? — AD7six
– AD7six, Commented May 31, 2014 at 19:17

bancer · Accepted Answer · 2014-05-31 14:08:19Z

2

CakePHP handles the quotes according to the actual column datatype. But if you really want to force quotes try this:

$this->set('scales', $this->Scale->find('list', array(
    'conditions' => array("Scale.enabled='1'")
)));

answered May 31, 2014 at 14:08

bancer

7,5257 gold badges41 silver badges60 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1