How to write followin query in cakephp
$sql = "select
devices.uid,devices.agent,devices.capabilities,devices.localcaps from
devices,agents where devices.uid = agents.uid and agents.verified=1
limit 100";
Following is my controller file
class AgentsController extends AppController {
var $name = 'Agents';
var $helpers = array('Html','Form','Xml','Text','Javascript','Ajax');
var $uses = array( 'Agent','Device');
var $components = array('RequestHandler');
function admin_exportDevice(){
$this->_adminOnly();
$export = trim($this->data['deviceExport']['export']);
if($export=='Full'){
$sql = "select
devices.uid,devices.agent,devices.capabilities,devices.localcaps from
devices,agents where devices.uid = agents.uid and agents.verified=1
limit 100";
$qry = mysql_query($sql);
$this->set('qry', $qry);
$this->set('filename', 'Full'.date("Ymd").'.xml');
$this->layout='ajax';
//$this->Device->updateAll(array('Device.export' =>1),array
('Device.export'=>0));
$sql1 = "Update devices set export=1 where export=0";
$query = mysql_query($sql1);
}
else{
$sql = "select
devices.uid,devices.agent,devices.capabilities,devices.localcaps from
devices,agents where devices.uid = agents.uid and agents.verified=1
and devices.export=0 limit 2";
$qry = mysql_query($sql);
$this->set('qry', $qry);
$this->set('filename', 'Incremental'.date("Ymd").'.xml');
$this->layout='ajax';
$sql1 = "Update devices set export=1 where export=0";
$query = mysql_query($sql1);
//$this->Device->updateAll(array('Device.export' =>1),array
('Device.export'=>0));
}
}
}
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" 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?hl=en
-~----------~----~----~----~------~----~------~--~---
