livewire-datatables icon indicating copy to clipboard operation
livewire-datatables copied to clipboard

Wrong Syntax for Order Column Names

Open SDJeff opened this issue 4 years ago • 0 comments

I am using here MSSQL and i got an error if columns are configured because of the order by Clause.

SQLSTATE[HY000]: General error: 20018 Incorrect syntax near '`'

I think it will be a problem with the syntax depending of the quotes because the column name is wrapped in simple quotes like: order by `Gruppe` desc

The correct syntax should be

ORDER BY 'Gruppe' DESC

SDJeff avatar Feb 05 '22 07:02 SDJeff