laravel-msaccess

laravel-msaccess copied to clipboard

[2019-08-16 05:01:33] local.DEBUG: [27.02ms] select top 2 * from [dajg_base] order by 1 asc | GET: / [2019-08-16 05:01:33] local.ERROR: SQLSTATE[42000]: Syntax error or access violation: -3100 [Microsoft][ODBC Microsoft Access ��������] �﷨���� (��������ʧ) �ڲ�ѯ���ʽ 'row_number() over (order by 1 asc)' �С� (SQLExecute[-3100] at ext\pdo_odbc\odbc_stmt.c:258) (SQL: select * from (select top 2 *, row_number() over (order by 1 asc) as row_num from [dajg_base]) as temp_table where row_num between 3 and 4 order by row_num)

$results = \Illuminate\Support\Facades\DB::connection('access')->table('dajg_base')->offset($offset) ->limit($count) ->get();