Query builder missing value quotes

When i run the following code I get an sql error

    \DB::connection('utskrift')->table('utskrift')->insert(
      ['varenummer' => 123, 'navn' => 'test navn', 'leverandor' => 22, 'leverandor_varenummer' => 'test 123', 'antall' => 1, 'printer' => 'printer 1']
    );

After inspecting the error the returned query is

insert into [utskrift] ([varenummer], [navn], [leverandor], [leverandor_varenummer], [antall], [printer]) values (123, test navn, 22, test 123, 1, printer 1)

When I run the query with quotes it works.

insert into [utskrift] ([varenummer], [navn], [leverandor], [leverandor_varenummer], [antall], [printer]) values (123, 'test navn', 22, 'test 123', 1, 'printer 1')

How can I make query builder generate the sql with quotes?

EDIT I'm using the sqlsrv driver with mssql

jlrdw

6 years ago

Level 75

The docs does show your code should work: From docs

DB::table('users')->insert(
    ['email' => '[email protected]', 'votes' => 0]
);

Only apostrophes are being used, I thought all was tested, but could be a bug.

See if there's been any issues. Of course this data is usually in variables.

Please or to participate in this conversation.