diff artifact-database/src/main/resources/sql/org-h2-driver.properties @ 213:199f0e553e3a

Bugfix: Repaired broken SQL statement. artifacts/trunk@1550 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Ingo Weinzierl <ingo.weinzierl@intevation.de>
date Wed, 23 Mar 2011 16:20:11 +0000
parents face2302387c
children a9c8fa38ba03
line wrap: on
line diff
--- a/artifact-database/src/main/resources/sql/org-h2-driver.properties	Wed Mar 23 12:08:21 2011 +0000
+++ b/artifact-database/src/main/resources/sql/org-h2-driver.properties	Wed Mar 23 16:20:11 2011 +0000
@@ -81,7 +81,7 @@
 collection.items.list.gid= \
     SELECT a.gid, ci.attribute FROM collection_items ci \
     INNER JOIN artifacts a ON ci.artifact_id = a.id \
-    WHERE ci.id IN (SELECT id FROM collections WHERE gid = ?)
+    WHERE ci.collection_id IN (SELECT id FROM collections WHERE gid = ?)
 
 # COLLECTIONS
 collections.touch.by.gid =\

http://dive4elements.wald.intevation.org