+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Development (https://forum.codeigniter.com/forumdisplay.php?fid=6)
+--- Forum: Issues (https://forum.codeigniter.com/forumdisplay.php?fid=19)
+--- Thread: Error 2014 with two stored procedures (/showthread.php?tid=67532)
Error 2014 with two stored procedures - fvandal - 03-06-2017
Hello everyone
i know i'm not the first one to post about the Error 2014
but here is my problem
my code look like this:
$data['listFabriquant'] = json_encode($this->CatalogueModel->getListNomFabriquant());
$data['listType'] = json_encode($this->CatalogueModel->getListNomType());
boom error 2014 on page exec
2 stored procs are called one after another
they are on the same model that is fetch earlier in the function
i have seen a lot of workaround for that error but none were even close to my problem
i saw a lot a people calling 2 stored procs in one query, i personnaly call 2 stored procs in 2 query, one call each
the many workaround i have seen are not to my liking ( editing core file wth?)
i want data from the database on my page load to fetch data for my 2 select in my web page
is my approach wrong? did i forgot a step? is that a codeigniter limitation?
i am currently looking for a better framework that dont have those silly limitation
if you can help me in the mean time that would be great since i would not have to recode my site
thanks in advance and tell me if you need more detail