From f9f4f63fc33049308eab7853c0996f19164a68a7 Mon Sep 17 00:00:00 2001 From: Joey Hagedorn Date: Fri, 4 Aug 2006 18:50:26 +0000 Subject: 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 --- reports/brpt/reports/views.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'reports') 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]) -- cgit v1.2.3-1-g7c22