According to the docs, the call to sqlsrv_query() should look like this:
mixed sqlsrv_query ( resource $conn , string $sql [, array $params [, array $options ]] )
But let's say I" want to do a simple SELECT query with no params, but I do want to pass some options?
This snippet seems to work erratically,
$dbh = blah...blah...
$query = 'SELECT * FROM myTable';
$options = array('Scrollable' => SQLSRV_CURSOR_CLIENT_BUFFERED);
$statement = sqlsrv_query($dbh, $query, array(), $options);
sometimes returning this error from sqlsrv_error():
Array
(
[0] => Array
(
[0] => IMSSP
[SQLSTATE] => IMSSP
[1] => -14
[code] => -14
[2] => An invalid parameter was passed to sqlsrv_query.
[message] => An invalid parameter was passed to sqlsrv_query.
)
)
What is the correct way to pass options to sqlsrv_query but not parameters?
Per suggestions below, I've also tried $statement = sqlsrv_query($dbh, $query, null, $options);
with the same results.
Thanks!