What is the error you get? What is the query that is passed to the db? $f is what before is been sent?
On Sunday, February 10, 2013 11:38:36 AM UTC-5, Diego Turcios wrote: > > Hi > > I need a view with two textbox for getting this values for doing a query > > This is my view reporteiario.ctp > >> <h1>Reporte Diario</h1> <?php echo $this->Form->create('dates'); echo >> $this->Form->input('Inicio'); echo $this->Form->input('Fin'); echo $this >> ->Form->end('Generar Reporte'); ?> > > > This is my function in my controller > public function reportediario() { if ($this->request->is('post')) { $d= > $this->request->data['dates']['inicio']; $q = "SELECT * from table WHERE > Fecha >= "; $f=$q.$d; $this->set('vwrecords',$this->Vwrecord->query($f) > ); } >> >> } > > > The problem is I am getting a database error. I can't request the data > from the text box. > Any idea? > >> > > -- Like Us on FaceBook https://www.facebook.com/CakePHP Find us on Twitter http://twitter.com/CakePHP --- You received this message because you are subscribed to the Google Groups "CakePHP" group. To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscr...@googlegroups.com. To post to this group, send email to cake-php@googlegroups.com. Visit this group at http://groups.google.com/group/cake-php?hl=en. For more options, visit https://groups.google.com/groups/opt_out.