diff options
| author | Bond_009 <bond.009@outlook.com> | 2020-04-03 17:30:01 +0200 |
|---|---|---|
| committer | Bond_009 <bond.009@outlook.com> | 2020-04-03 17:30:01 +0200 |
| commit | 3161e85f7678aab603eb2f0180a2b911207e477e (patch) | |
| tree | 55bf6be00b74f85447d685d3f79983725a71bd66 /Emby.Server.Implementations/Data/SqliteItemRepository.cs | |
| parent | f6c9a44703cfee7c99b333db8c06160c50c67754 (diff) | |
Address comments
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..e360b790c 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>(); |