Re: 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 associative array with empty values. If I fetch all, PHP runs out of memory but the arrays in array are the same, keys without values. On Tue, Jan 26, 2016 at 9:17 AM, Lester Caine <lester@lsces.co.uk> wrote: > 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 named parameters because a specific > > number can be repeated. > > This is the key to your problem ... > > The PDO generic process does not support named parameters directly, so > the ? format duplicating the multiple use of a named parameter is > required ... if the driver actually supports that? > > Does your setup work if the SQL is > > $stmt = $dbh->prepare("SELECT * FROM dummy WHERE col1=? AND col2=? AND > col3=?"); > $stmt->bindParam(1, $S1); > $stmt->bindParam(2, $S2); > $stmt->bindParam(3, $S1); > > On some drivers the named parameters have to be converted to '?' format, > but I can't find the notes now on what combination works and what does't :( > > -- > Lester Caine - G8HFL > ----------------------------- > Contact - http://lsces.co.uk/wiki/?page=contact > L.S.Caine Electronic Services - http://lsces.co.uk > EnquirySolve - http://enquirysolve.com/ > Model Engineers Digital Workshop - http://medw.co.uk > Rainbow Digital Media - http://rainbowdigitalmedia.co.uk > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >