ref 31 is not solved still: reopen

[yavasura]

the above code do not work also:

sql looks like this: select SQL_CALC_FOUND_ROWS name,(select name from region where region.region_id = region.id ) region,id,region_id from region order by (select name from region where region.region_id = region.id ) limit 0, 25 []

my code:

class Model_Region extends Model_Table { public $table='region'; function init(){ parent::init(); $this->addField('name')->mandatory('true'); $this->hasOne('Region_Parent','region_id'); } }

class Model_Region_Parent extends Model_Region { public $alias='region_parent'; }

class page_region extends Page { function init(){ parent::init(); $crud=$this->add('CRUD'); $model = $crud->setModel('Model_Region'); $model->debug(); if($crud->grid){ $crud->grid->addPaginator(); $crud->grid->getColumn('name')->makeSortable(); $crud->grid->getColumn('region')->makeSortable(); $crud->grid->addQuickSearch(array('region','name')); } } }

[yavasura]

somebody please propose some solution!!!

I would like to propose in stead of using real table name to give it unique alias while generating sql.

What do you think?