laravel-pdo-odbc icon indicating copy to clipboard operation
laravel-pdo-odbc copied to clipboard

Insert stmt not inserting anything

Open c00p3r opened this issue 2 years ago • 8 comments

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!

c00p3r avatar Jul 05 '22 11:07 c00p3r