diff options
| author | dkanada <dkanada@users.noreply.github.com> | 2020-04-06 18:59:45 +0900 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2020-04-06 18:59:45 +0900 |
| commit | cb634d27d8f66ce05d21610226306e80c47af959 (patch) | |
| tree | 05aeb5429bf7baf757fb99addf9c11c8ba986406 /Emby.Server.Implementations/Data | |
| parent | de634203d812922bb04359a32e59189fb0110791 (diff) | |
| parent | 19b6961c0890df8461a07039c0a3edbb9a276120 (diff) | |
Merge branch 'master' into use-development-exception-page
Diffstat (limited to 'Emby.Server.Implementations/Data')
| -rw-r--r-- | Emby.Server.Implementations/Data/SqliteItemRepository.cs | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/Emby.Server.Implementations/Data/SqliteItemRepository.cs b/Emby.Server.Implementations/Data/SqliteItemRepository.cs index e3242f7b4..46c6d5520 100644 --- a/Emby.Server.Implementations/Data/SqliteItemRepository.cs +++ b/Emby.Server.Implementations/Data/SqliteItemRepository.cs @@ -5011,6 +5011,11 @@ where AncestorIdText not null and ItemValues.Value not null and ItemValues.Type commandText += " order by ListOrder"; + if (query.Limit > 0) + { + commandText += " LIMIT " + query.Limit; + } + using (var connection = GetConnection(true)) { var list = new List<string>(); @@ -5049,6 +5054,11 @@ where AncestorIdText not null and ItemValues.Value not null and ItemValues.Type commandText += " order by ListOrder"; + if (query.Limit > 0) + { + commandText += " LIMIT " + query.Limit; + } + using (var connection = GetConnection(true)) { var list = new List<PersonInfo>(); |