summaryrefslogtreecommitdiffstats
path: root/reports/brpt
diff options
context:
space:
mode:
authorJoey Hagedorn <hagedorn@mcs.anl.gov>2006-08-04 18:50:26 +0000
committerJoey Hagedorn <hagedorn@mcs.anl.gov>2006-08-04 18:50:26 +0000
commitf9f4f63fc33049308eab7853c0996f19164a68a7 (patch)
treed00dba9c726c3bd33dba0e5f91e9c77802bfed6b /reports/brpt
parent53bcb121c982db6194620040cc60f011a43a6ac6 (diff)
downloadbcfg2-f9f4f63fc33049308eab7853c0996f19164a68a7.tar.gz
bcfg2-f9f4f63fc33049308eab7853c0996f19164a68a7.tar.bz2
bcfg2-f9f4f63fc33049308eab7853c0996f19164a68a7.zip
New Reports: Minor change in effort to make more compatible with SQLite
git-svn-id: https://svn.mcs.anl.gov/repos/bcfg/trunk/bcfg2@2042 ce84e21b-d406-0410-9b95-82705330c041
Diffstat (limited to 'reports/brpt')
-rw-r--r--reports/brpt/reports/views.py2
1 files changed, 1 insertions, 1 deletions
diff --git a/reports/brpt/reports/views.py b/reports/brpt/reports/views.py
index da41d0862..de71162a8 100644
--- a/reports/brpt/reports/views.py
+++ b/reports/brpt/reports/views.py
@@ -68,7 +68,7 @@ def config_item_bad(request, eyedee = None, timestamp = 'now'):
interactionlist = []
[interactionlist.append(x.id) for x in interact_queryset]
if not interactionlist == []:
- cursor.execute("select client_id from reports_interaction, reports_bad_interactions, reports_client "+
+ cursor.execute("SELECT DISTINCT client_id from reports_interaction, reports_bad_interactions, reports_client "+
"WHERE reports_bad_interactions.interaction_id IN %s "+
"AND reports_bad_interactions.interaction_id = reports_interaction.id "+
"AND reports_bad_interactions.bad_id = %s", [interactionlist, eyedee])