Re: [PHP-DB] PDO and SAP HANA prepared statements issue

Your answer in the part of SAP HANA (J)ODBC driver not supporting named parameters actually makes sense. However I don't understand why would there be a difference between PDO and regular odbc (odbc_connect, etc.) commands since they're obviously using the same driver. My testing machine is on

Re: [PHP-DB] PDO and SAP HANA prepared statements issue

On Jan 26, 2016, at 7:10 AM, Alko Kotalko wrote: > Hi, > > I have a working connection from PHP to SAP HANA through PDO and regular > ODBC commands. > > The issue is that through PDO I can not get any prepared statements to > work. None of the notations (?, $, :) work.

Re: [PHP-DB] PDO and SAP HANA prepared statements issue

Greetings, On 01/26/2016 08:18 AM, Karl DeSaulniers wrote: > On Jan 26, 2016, at 7:10 AM, Alko Kotalko wrote: > >> Hi, >> >> I have a working connection from PHP to SAP HANA through PDO and regular >> ODBC commands. >> [...snipped...] >> >> For example: >> "SELECT *

Re: [PHP-DB] PDO and SAP HANA prepared statements issue

On 26/01/16 13:10, Alko Kotalko wrote: > ODBC commands actually work with the ? and colon ($) notations. But not > with colon (:). I suppose this is due to the lack of named parameters > support in ODBC commands (haven't actually confirmed that though). The $ > notation brings me the closest to

Re: [PHP-DB] PDO and SAP HANA prepared statements issue

I've tried all the notations with PDO as well and none of them work with SAP HANA. It works with MySQL though. So I presume that there is either a bug in PDO driver or there is some mismatch between PDO and SAP HANA. The queries get executed but the returned result (if I fetch one) is an

Re: [PHP-DB] PDO and SAP HANA prepared statements issue

It shouldn't be like that because I'm preparing a statement, which would later have had parameters passed to. I'm not trying to concatenate a string. (Sorry, forgot to reply to all before) On Tue, Jan 26, 2016 at 8:18 AM, Karl DeSaulniers wrote: > On Jan 26, 2016, at 7:10

Re: [PHP-DB] PDO and SAP HANA prepared statements issue

This (my code) actually works so it's not part of the problem. The problem is that I can NOT use the colon notation for named parameters, even though that's my goal :) If I use the colon notation with MySQL (PDO) it works fine. With ODBC and SAP HANA database it doesn't. I have to use either ? or

Re: [PHP-DB] PDO and SAP HANA prepared statements issue

Oh ok, thanks for the clarification. Sorry for the noise. Best, Karl DeSaulniers Design Drumm http://designdrumm.com On Jan 26, 2016, at 1:07 PM, Alko Kotalko wrote: > It shouldn't be like that because I'm preparing a statement, which would > later have had

Re: [PHP-DB] PDO and SAP HANA prepared statements issue

On 26/01/16 19:06, Alko Kotalko wrote: > I've tried all the notations with PDO as well and none of them work with > SAP HANA. It works with MySQL though. So I presume that there is either a > bug in PDO driver or there is some mismatch between PDO and SAP HANA. Firebird does not support named