I'm connecting true the ODBC driver form PHP to the denodo database.
I'm using pdo and want to make use of binding parameters in de code.
e.q.:
This works:
$denodo = new DenodoDatabase();
$sql = "SELECT * from orders where ordernumber = 20753852 limit 10";
$denodo->query($sql, true);
$array = $denodo->resultset();
This is NOT working
$denodo = new DenodoDatabase();
$sql = "SELECT * from orders where ordernumber =? limit 10";
$denodo->query($sql, true);
denodo->bind('1' ,'20753852');
$array = $denodo->resultset();
This is also NOT working
$denodo = new DenodoDatabase();
$sql = "SELECT * from orders where ordernumber = :ordernumber limit 10";
$denodo->query($sql, true);
denodo->bind(':ordernumber','20753852');
$array = $denodo->resultset();
How can this be made working, it seems that the supplied ODBC driver noet supports it.
kind regards,
Aren