From 8a101f6b70a7407bdc7408083cb280cb14ba3bce Mon Sep 17 00:00:00 2001 From: methodus Date: Wed, 31 Oct 2012 18:32:39 +0100 Subject: Fixed sql statement of sort criteria. --- media/mediaManager.cpp | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'media') diff --git a/media/mediaManager.cpp b/media/mediaManager.cpp index c59e357..5bd02eb 100644 --- a/media/mediaManager.cpp +++ b/media/mediaManager.cpp @@ -425,11 +425,11 @@ int cMediaManager::Browse(BrowseRequest& request){ cSortCriteria::SortCriteriaList list = cSortCriteria::parse(request.sortCriteria); if(!list.empty()){ - metadata << " ORDER BY "; + metadata << " ORDER BY `"; upnp::cSortCriteria::SortCriteriaList::iterator it = list.begin(); - metadata << (*it).property << " " << ((*it).sortDescending ? "DESC" : "ASC"); + metadata << (*it).property << "` " << ((*it).sortDescending ? "DESC" : "ASC"); for(++it; it != list.end(); ++it){ - metadata << ", " << (*it).property << " " << ((*it).sortDescending ? "DESC" : "ASC"); + metadata << ", `" << (*it).property << "` " << ((*it).sortDescending ? "DESC" : "ASC"); } } -- cgit v1.2.3