So I have the following.. I am trying to load a SQL file like this.
$params = array(
'foo' => 'test',
'bar' => 'case'
);
$filename = 'test.sql';
$sql = $this->load->file($filename, true);
$query = $this->sedona_db->query($sql,$params);
the 'test.sql' file looks something like this:
Declare @foo varchar(10) = ?
Declare @bar varchar(10) = ?
Select * ... something something where foo = @foo
Exec someStoredProc @foo
--------------------------------------
I would get an error msg like this:
mssql_query(): message: Must declare the scalar variable "@foo"(severity 15)