diff options
| author | Joey Hagedorn <hagedorn@mcs.anl.gov> | 2006-08-04 18:50:26 +0000 |
|---|---|---|
| committer | Joey Hagedorn <hagedorn@mcs.anl.gov> | 2006-08-04 18:50:26 +0000 |
| commit | f9f4f63fc33049308eab7853c0996f19164a68a7 (patch) | |
| tree | d00dba9c726c3bd33dba0e5f91e9c77802bfed6b /reports | |
| parent | 53bcb121c982db6194620040cc60f011a43a6ac6 (diff) | |
| download | bcfg2-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')
| -rw-r--r-- | reports/brpt/reports/views.py | 2 |
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]) |