livewire-datatables
livewire-datatables copied to clipboard
Wrong Syntax for Order Column Names
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