Welcome Guest, Not a member yet? Register   Sign In
Model query builder problem!
#1

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.
Reply


Messages In This Thread
Model query builder problem! - by corvus - 05-27-2018, 08:12 PM
RE: Model query builder problem! - by InsiteFX - 05-28-2018, 03:45 AM



Theme © iAndrew 2016 - Forum software by © MyBB