Re: 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 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