I just started working with the deep relationships ! AWESOME work I have to say phil ! It works like a glove ! Thanks !
But it seens to be a problem when including all the fields from a related object like:
Code:
$obj = new Company();
$obj->include_related('presponsavel/cpf', 'stNumero');
$obj->include_related('presponsavel/rg', 'stNumero');
$obj->include_related('presponsavel/oab', 'stNumero');
$obj->include_related('presponsavel/enderecoprincipal', array('nmCep','stLogradouro','nmNumero ','stComplemento','stBairro','stCidade', 'stEstado','isAtivo','created','updated')); //THOSE ARE ALL THE FIELDS FROM THE TABLE
$obj->where('id',$this->uri->segment(3));
$obj->get();
So.. it would be easier just to do this:
$obj->include_related('presponsavel/enderecoprincipal','*'); --> That should include all the fields... but it doesnt...
It give me this error:
Code:
A Database Error Occurred
Error Number: 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`) LEFT OUTER JOIN `pfisicas` as presponsavel_pfisicas ON `presponsavel_pfisicas' at line 1
SELECT `companies`.*, `presponsavel_cpf_documentos`.`stNumero` AS presponsavel_cpf_stNumero, `presponsavel_rg_documentos`.`stNumero` AS presponsavel_rg_stNumero, `presponsavel_oab_documentos`.`stNumero` AS presponsavel_oab_stNumero, `presponsavel_enderecoprincipal_enderecos`.` AS presponsavel_enderecoprincipal_ FROM (`companies`) LEFT OUTER JOIN `pfisicas` as presponsavel_pfisicas ON `presponsavel_pfisicas`.`id` = `companies`.`presponsavel_id` LEFT OUTER JOIN `documentos` as presponsavel_cpf_documentos ON `presponsavel_cpf_documentos`.`id` = `presponsavel_pfisicas`.`cpf_id` LEFT OUTER JOIN `documentos` as presponsavel_rg_documentos ON `presponsavel_rg_documentos`.`id` = `presponsavel_pfisicas`.`rg_id` LEFT OUTER JOIN `documentos` as presponsavel_oab_documentos ON `presponsavel_oab_documentos`.`id` = `presponsavel_pfisicas`.`oab_id` LEFT OUTER JOIN `enderecos` as presponsavel_enderecoprincipal_enderecos ON `presponsavel_enderecoprincipal_enderecos`.`id` = `presponsavel_pfisicas`.`enderecoprincipal_id` WHERE `companies`.`id` = '18'
I think this is a BUG... because it works perfectly in the non-deep relationships.
