diff options
| author | Dan Goodliffe <dan@randomdan.homeip.net> | 2015-08-21 15:48:12 +0100 |
|---|---|---|
| committer | Dan Goodliffe <dan@randomdan.homeip.net> | 2015-08-21 15:48:12 +0100 |
| commit | c495a745d0318a3a009ac5a7f07951217190c37d (patch) | |
| tree | ca3021d10725f1b5b597e82714a293faa0313611 | |
| parent | Correct the owner of filterspec and related operator (diff) | |
| download | gentoobrowse-c495a745d0318a3a009ac5a7f07951217190c37d.tar.bz2 gentoobrowse-c495a745d0318a3a009ac5a7f07951217190c37d.tar.xz gentoobrowse-c495a745d0318a3a009ac5a7f07951217190c37d.zip | |
Fix herd in category view now DB correctly contains nulls, not empty stringsgentoobrowse-1.1.0.1
| -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> |