From 102940630129d3e939731da43acffdf7f60f6d16 Mon Sep 17 00:00:00 2001 From: methodus Date: Sat, 3 Nov 2012 16:41:38 +0100 Subject: Fixed missing res@protocolInfo in BrowseRequest --- media/mediaManager.cpp | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) (limited to 'media') diff --git a/media/mediaManager.cpp b/media/mediaManager.cpp index e8f25e6..c61a7ae 100644 --- a/media/mediaManager.cpp +++ b/media/mediaManager.cpp @@ -404,7 +404,9 @@ int cMediaManager::Browse(BrowseRequest& request){ metadata << "SELECT *,(SELECT COUNT(1) FROM " << db::Metadata << " m WHERE " << "m.`" << property::object::KEY_PARENTID << "` = " << "p.`" << property::object::KEY_OBJECTID << "`) as " - << "`" << property::object::KEY_CHILD_COUNT << "` FROM " << db::Metadata << " p WHERE "; + << "`" << property::object::KEY_CHILD_COUNT << "`," + << "r.`" << property::resource::KEY_PROTOCOL_INFO << "` FROM " << db::Metadata << " p " + << "LEFT JOIN " << db::Resources << " r USING (`" << property::object::KEY_OBJECTID << "`) WHERE "; count << "SELECT COUNT(1) as totalMatches FROM " << db::Metadata << " WHERE "; -- cgit v1.2.3