Zend framework - Zend_db_table_abtract select()

Question

I want to use select() where I can get just one column without specifying the table name. (Table name is in the $_name var declared in my model.) I tried this:

$select->columns('field');

.. but I get error of "No table has been specified for the FROM clause" - so it looks like it's expecting a table name.

Is there a way of getting just one column?

Where does $select come from?

Tim Fountain
– Tim Fountain

2011-08-25 08:13:06 +00:00
Commented Aug 25, 2011 at 8:13 — Tim Fountain
– Tim Fountain, Commented Aug 25, 2011 at 8:13

adlawson · Accepted Answer · 2011-08-25 08:08:57Z

2

The error is correct. You need to specify a table you want the field from.

$select->from('table_name', array('field'));

answered Aug 25, 2011 at 8:08

adlawson

6,4291 gold badge37 silver badges46 bronze badges

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

Comments

Hari K T · Accepted Answer · 2011-08-25 09:54:35Z

1

If your class extends the Zend_Db_Table_Abstract, you can use $this->fetchAll() , so no table name need to be specified.

If you still want to use select() pass the $this->_name as you have already declared the value $_name .

$this->select()->from($this->_name);

select() is mainly used to create a select query object, so it cannot guess from which table you are going to though currently you are in the model. It may not be for a query on the same table. So you should pass the table name. For more see http://framework.zend.com/manual/en/zend.db.select.html . All are for different purposes. So you want to use according to your wish.

edited Aug 25, 2011 at 9:54

answered Aug 25, 2011 at 8:08

Hari K T

4,2644 gold badges34 silver badges56 bronze badges

4 Comments

Owen Over a year ago

Using $this->_fetch() how do I specify a column name?

Owen Over a year ago

Sorry, I meant How do I specify a column name without a table name?

Hari K T Over a year ago

All the columns will be fetched.

Hari K T Over a year ago

Or in simple sentence select() is developed to work like that. Or you want to extend and make the necessary changes to work like what you want.

Collectives™ on Stack Overflow

Zend framework - Zend_db_table_abtract select()

2 Answers 2

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related