hasOne relation when primary and foreign key are the same
I have to access some table created by others outside of cakephp.
2 of the tables are related by a hasOne relationship but the second
table has a primary key that is *the* foreign key. Please don't ask! :-
(
I can't change the tables.
I used the following models in cake:
table1:
class t1 extends AppModel {
var $name = 't1';
var $useDbConfig = 'other';
var $useTable = 'externalt1';
var $hasOne = array(
'T2' = array(
'className' = 'T2',
'foreignKey' = 'id',
'dependent' = false,
'conditions' = '',
'fields' = '',
'order' = ''
)
);
}
table2:
class T2 extends AppModel {
var $name = 'T2';
var $useDbConfig = 'other';
var $useTable = 'externalt2';
}
In the t1 controller I put a find('all'):
$this-log($this-T1-find('all')); // in index (just a test)
But when I go to T1s address I get a blank page and nothing in the log
file.
Is there a cake way to access the data of the 2 tables?
thanks
maxx
Check out the new CakePHP Questions site http://cakeqs.org and help others with
their CakePHP related questions.
You received this message because you are subscribed to the Google Groups
CakePHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
Re: hasOne relation when primary and foreign key are the same
On Fri, Sep 10, 2010 at 6:55 AM, emmexx emmeics...@gmail.com wrote:
I have to access some table created by others outside of cakephp.
2 of the tables are related by a hasOne relationship but the second
table has a primary key that is *the* foreign key. Please don't ask! :-
(
I can't change the tables.
I used the following models in cake:
table1:
class t1 extends AppModel {
var $name = 't1';
var $useDbConfig = 'other';
var $useTable = 'externalt1';
var $hasOne = array(
'T2' = array(
'className' = 'T2',
'foreignKey' = 'id',
'dependent' = false,
'conditions' = '',
'fields' = '',
'order' = ''
)
);
}
table2:
class T2 extends AppModel {
var $name = 'T2';
var $useDbConfig = 'other';
var $useTable = 'externalt2';
}
In the t1 controller I put a find('all'):
$this-log($this-T1-find('all')); // in index (just a test)
But when I go to T1s address I get a blank page and nothing in the log
file.
That may be a fatal error. If PHP craps out it won't be able to log
anything. Check your server's log.
Check out the new CakePHP Questions site http://cakeqs.org and help others with
their CakePHP related questions.
You received this message because you are subscribed to the Google Groups
CakePHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
Re: hasOne relation when primary and foreign key are the same
On 10 Set, 20:08, cricket zijn.digi...@gmail.com wrote:
That may be a fatal error. If PHP craps out it won't be able to log
anything. Check your server's log.
Too lazy to check apache logs... :-(
PHP Fatal error: Allowed memory size of 33554432 bytes exhausted
(tried to allocate 4198401 bytes) in /var/www/htdocs/cake/libs/
object.php on line 158
It was a find('all') without limits and conditions.
Thank you
maxx
Check out the new CakePHP Questions site http://cakeqs.org and help others with
their CakePHP related questions.
You received this message because you are subscribed to the Google Groups
CakePHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
