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 para
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 parameters passed to. I'm not try
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 AM, Alko Kotalko wrote
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
$
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
associati
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 nam
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 * FROM dummy WHERE col1=$1 AND
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. The response from the ser
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. The response from the server
(fetch) gets me empty field values for all selected columns a
