I use a mysql view:
--------------------------------------------------------------------------------------------------------------------------
create view `view_servererror` as
SELECT service_error_log.service_error_log_id,
service_error_log.datecreated, server.server_name,
server.server_ip_lan, service.service_name, service.service_note,
error_type.error_desc, error_type.error_type_note,
server_service.server_service_id
FROM ((server INNER JOIN server_service ON server.server_id =
server_service.server_id) INNER JOIN service ON
server_service.service_id = service.service_id) INNER JOIN (error_type
INNER JOIN service_error_log ON error_type.error_type_id =
service_error_log.error_type_id) ON server_service.server_service_id =
service_error_log.server_service_id;
--------------------------------------------------------------------------------------------------------------------------
My controller:
$serviceerror=$this->Serviceerror->findAll($tj,null,$this->sortBy." "
.$this->direction ,$this->show,$this->page);
$this->set('serviceerror',$serviceerror);
--------------------------------------------------------------------------------------------------------------------------
My model:
<?PHP
class serviceerror extends AppModel {
var $name ='serviceerror';
//var $primaryKey="service_error_log_id";
var $useTable="view_servererror";
}
?>
--------------------------------------------------------------------------------------------------------------------------
error message:
Notice: Undefined index: service_error_log in
E:\View\sourcecode\cake\libs\model\datasources\dbo_source.php on line
572
Fatal error: Cannot access empty property in
E:\View\sourcecode\cake\libs\model\datasources\dbo_source.php on line
572
--------------------------------------------------------------------------------------------------------------------------
How resolve it?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cake-php
-~----------~----~----~----~------~----~------~--~---
