I want to run a mssql query that has a part of the user defined function. This is my code:
$connection = $this->em->getConnection();
$sql = 'select * from ssm.table where ip = dbo.fn_ConvertIpAddressToBinary(\'192.168.0.1\')';
$result = $connection->executeQuery($sql);
$results = $result->fetchAll();
var_dump($results);
However, I get a blank response. If you set the request without function, everything works fine. This query works fine in sql query analyzer.
What can I do wrong?