i use 2 dbConfigs one conncects to mysql the other connects to SQL
Server
so Detail is Sql Server
and DataDetail is Mysql
this is my code so far
any idea how i can do this
i get this error
is it possiable to do a beforeSave{} to see if the data exists import
new ones
Allowed memory size of 134217728 bytes exhausted (tried to
allocate 43 bytes)
function import() {
$this->loadModel('Detail');
$data = array();
$batch = $this->Detail->find('all');
$this->set('batch',$batch);
foreach($batch as $b){
$data[] = array('DataDetail' => array(
'id' => $b['Detail']['ID'],
'name' => $b['Detail']['name']
));
}
$this->DataDetail->create();
if ($this->DataDetail->saveAll($data)){
$this->redirect(array('action' => 'index'));
$this->Session->setFlash(__('The details has been Imported',
true));
}
}
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with their CakePHP related questions.
To unsubscribe from this group, send email to
[email protected] For more options, visit this group at
http://groups.google.com/group/cake-php
