Select a dummy column with a dummy value in Zend framework Select?

Question

How can i specify Zend Db Table Select to fetch a dummy column.

i want to generate sql like this

SELECT 'ABC' AS xyz , name FROM employee

Edit:

I have tried this

$select->from('employee',array( 
        'xyz'=>'ABC',
        'name'
));

and also as

$select->from('employee',"'ABC' AS xyz , name"));

in both cases Zend intelligently considers 'ABC' as a field in schema. so it generate something like

SELECT `employee`.`'ABC'` AS `xyz` , `name` FROM `employee`

which produces error as ABC is not a field of employee

Can't you just add those columns in your code? Why do you need those "dummy columns"? — feeela, Dec 08 '12 at 22:17
i have edited my question. please re read, i appreciate you quick response — Rasikh Mashhadi, Dec 08 '12 at 22:26

score 8 · Accepted Answer · edited Dec 09 '12 at 21:37

8

You should try

$select->from ('employee', array (new Zend_Db_Expr ('"ABC" AS title'), 'name'));

edited Dec 09 '12 at 21:37

Marvo

answered Dec 09 '12 at 10:56

akond

And how can make its alias like 'ABC' AS title ? – Rasikh Mashhadi Dec 09 '12 at 19:20
1

Add an AS statement: `new Zend_Db_Expr ('"ABC" AS title')` – akond Dec 09 '12 at 21:37

1 Answers1