diff options
| author | Vasily <JustAMan@users.noreply.github.com> | 2020-04-04 01:38:09 +0300 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2020-04-04 01:38:09 +0300 |
| commit | d5cc10d7e1a62b98af1a675aaef5ca5379fe4363 (patch) | |
| tree | 3d5ae45418ce47e0c098150cdca70258715cabd5 /Emby.Server.Implementations/Data/SqliteItemRepository.cs | |
| parent | cda0574c8d70e68ec625fe9983eaa54501e694ff (diff) | |
| parent | 64692af1a23dafba2e67620478ffeae078244070 (diff) | |
Merge pull request #2741 from Bond-009/dlnawarnings2
Fix some warnings
Diffstat (limited to 'Emby.Server.Implementations/Data/SqliteItemRepository.cs')
| -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>(); |