CodeIgniter Forums
MSSQL pass array to stored procedure - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forum-5.html)
+--- Forum: General Help (https://forum.codeigniter.com/forum-24.html)
+--- Thread: MSSQL pass array to stored procedure (/thread-63437.html)



MSSQL pass array to stored procedure - Progressed - 10-30-2015

USING:

Codeigniter 3.0
Database driver: SQLSRV

I'm looking for a way to pass a complete array to a MSSQL stored procedure

$filter = array(
'PARAM1' => $this->input->get_post('VALUE1', TRUE),
'PARAM2' => $this->input->get_post('VALUE2', TRUE)
);

I've seen many examples, but none of theme work.

Hoping someone could help me into the right direction!