Skip to content
This repository has been archived by the owner on Nov 27, 2020. It is now read-only.

paging error #7

Open
onlyshow opened this issue Aug 16, 2019 · 0 comments
Open

paging error #7

onlyshow opened this issue Aug 16, 2019 · 0 comments

Comments

@onlyshow
Copy link

onlyshow commented Aug 16, 2019

[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();

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant