laravel-pdo-odbc
laravel-pdo-odbc copied to clipboard
Insert stmt not inserting anything
So I installed pdo_snowflake
oficial driver and this package
It finally works more or less
BUT
I create a table - works
I wanna insert data into that table - FAILS
I'm using laravel query builder like so
$res = DB::connection('snowflake')->table($tableName)->insert($data);
and $res
equals true
but when I look at DB table - it's empty
If I copy raw sql and execute it - works so my sql is CORRECT
My guess it's smtn specific to package So I wonder if that's related to issue described in docs:
Snowflake also doesn't support streaming bind values. Mainly when using ->prepare('..') statement and following by $stmt->bindValue(...) or $stmt->bindParam(). We added a CustomStatement class to resolve this issue.
My question is how do I go from here? What should I do to make it work?
use CustomStatement
class? but how? It's not clear
@yoramdelangen please help me out!