Thursday, July 9, 2015

How to execute stored procedure in cakephp 2.6 with mssql server 2005 ?

Hi everyboy,

It's been a a month now that i'm trying to execute and get the result of a stored procedure wich is located in mssql server with cakephp.
So far I've tried this :
$conn = $this->DevCondition->getDataSource('default');
$result
= $conn->query('Exec [dbo].[cond_docu_log_errors]');
debug
($result);
die();

 

When I test it it shows me this :
\app\Controller\TestsController.php (line 153)
array() 

Any Idea how i can retrive the data sended by my stored procedure ?

I'm really getting desperate over this so any advices or bit of informatiosn are welcome.

Thanks in advance,

The devil

--
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/d/optout.

No comments: