Re: CAKEPHP Call Store procedure

Add select query at the end or your stored procedure to return resultset of a table.

On Monday, December 2, 2013 2:42:57 PM UTC+5:30, Jorge Mariano Paz Flores wrote:

Hi does anyone knows how to execute a store procedure, all I get is empty result

here is my code...

in my model..

      public function procedure()

{

$result = $this->query("CALL ReporteEjesLineas(2013,1);");

return $result;

}

in my controller

public function admin_reportebarras($anio = null, $mes = null)

{

$datos = $this->Poa->procedure();

$this->set(compact( 'datos''));

}

and in my view

debug($datos)

but all i get is null even though i have some data.

--
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+unsubscribe@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.
For more options, visit https://groups.google.com/groups/opt_out.