I think, cake can be return true or false in $result.
Try find result for some select;
$this->begin();
$this->query("CALL procedure();");
$result = $this->query("SELECT something");
$this->commit();
2013/12/2 Jorge Mariano Paz Flores <[email protected]>
> 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 [email protected].
> To post to this group, send email to [email protected].
> Visit this group at http://groups.google.com/group/cake-php.
> For more options, visit https://groups.google.com/groups/opt_out.
>
--
***Se você pretende redirecionar este e-mail, por favor, apague todos os
endereços que aparecem nele. Outra dica de segurança é endereçá-lo no Cco.
Desta forma você estará protegendo a mim, seus amigos e a você mesmo. Eu e
a Campanha Contra o SPAM agradecemos.Não envie correntes.***
--
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 [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/groups/opt_out.
