diff options
| -rw-r--r-- | gentoobrowse/views/category.xml | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/gentoobrowse/views/category.xml b/gentoobrowse/views/category.xml index 01baa14..c14c2d2 100644 --- a/gentoobrowse/views/category.xml +++ b/gentoobrowse/views/category.xml @@ -3,7 +3,7 @@ xmlns:project2="http://project2.randomdan.homeip.net"> <project2:sqlrows name="categoryPackages" datasource="postgres-web"> <sql> - SELECT c.name AS catname, p.name AS pkgname, p.description, CASE WHEN p.herd = '' THEN '-none-' ELSE p.herd END as herd + SELECT c.name AS catname, p.name AS pkgname, p.description, COALESCE(herd, '-none-') herd FROM categories c, packages p WHERE c.categoryid = p.categoryid <filter name="byCatName">AND c.name = <param name="catname" /></filter> |