Unfortunately no....(:- I have an export csv option via a html link and i am not presenting this data to my view.
Please suggest if this can be achieved in controller itself. Regards Tapan Thapa India On Sun, Feb 20, 2011 at 8:08 PM, John Andersen <[email protected]>wrote: > Presentation of the data, your date and time fields, should be done in > the view, not in the controller, so just move the formatting to the > view. Would that be an acceptable solution for you? > Enjoy, > John > > On Feb 20, 2:58 pm, Tapan Kumar Thapa <[email protected]> > wrote: > > Hello Community, > > > > I have an export function in my controller. > > > > function export() { > > $this->layout = ''; > > $startdate = $this->Session->read('startdate'); > > $enddate = $this->Session->read('enddate'); > > $this->set('Export', $this->Incoming->find('all', array( > > 'fields' => array('date', 'time', 'msisdn', > 'shortcode', > > 'operator', 'circle', 'keyword', 'answer', 'age', 'gender'), > > 'order' => "Incoming.id desc", > > 'conditions' => array("Incoming.created >= > '$startdate' > > AND Incoming.created <= '$enddate' "), > > 'contain' => false))); > > } > > > > I want this control look like this. > > > > function export() { > > $this->layout = ''; > > $startdate = $this->Session->read('startdate'); > > $enddate = $this->Session->read('enddate'); > > $this->set('Export', $this->Incoming->find('all', array( > > 'fields' => array('date_format(date, '%d-%b-%y') as > > date', 'time', 'msisdn', 'shortcode', 'operator', 'circle', 'keyword', > > 'answer', 'age', 'gender'), > > 'order' => "Incoming.id desc", > > 'conditions' => array("Incoming.created >= > '$startdate' > > AND Incoming.created <= '$enddate' "), > > 'contain' => false))); > > } > > > > Please suggest. > > > > Regards > > Tapan Thapa > > India > > -- > 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 > -- 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
