Model query builder problem! - Printable Version

Model query builder problem! - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: General (https://forum.codeigniter.com/forumdisplay.php?fid=1)
+--- Forum: Regional User Groups (https://forum.codeigniter.com/forumdisplay.php?fid=25)
+--- Thread: Model query builder problem! (/showthread.php?tid=70766)

Model query builder problem! - corvus - 05-27-2018

Hi everyone!
I have a problem when use pure sql query in model function like this:

Code:
$query = "exec GetCellEqu @pShipId=N?,@pShipYear=N?,@pShipVoy=N?,@GroupFactor=N?";

$data = array(parameter1,parameter2,parameter3,parameter4);

$result = $this->db->query($query, $data)->result_array();

return $result;

and $result just return an empty array. But when i get that query string and run it in sql server, it able to return result.

Thanks.

RE: Model query builder problem! - InsiteFX - 05-28-2018

SEE: The CodeIgniter User's Guide - Query Builder

Query Binding