Changeset 16036


Ignore:
Timestamp:
2008-06-17T14:49:18+12:00 (16 years ago)
Author:
mdewsnip
Message:

(Adding dynamic classifiers) Fixed problem where documents appears twice in the classifier if they have two metadata values the same.

File:
1 edited

Legend:

Unmodified
Added
Removed

  • gsdl/trunk/src/lib/sqlitedbclass.cpp

    r16034 r16036  
    112112
    113113  // Get the entries in the "document_metadata" table where the element and value matches those specified
    114   text_t sql_cmd = "SELECT docOID FROM document_metadata WHERE element='" + sqlite_safe(metadata_element_name) + "' AND value='" + sqlite_safe(metadata_value) + "'";
     114  text_t sql_cmd = "SELECT DISTINCT docOID FROM document_metadata WHERE element='" + sqlite_safe(metadata_element_name) + "' AND value='" + sqlite_safe(metadata_value) + "'";
    115115
    116116  // If we're sorting the documents by a certain metadata element, extend the SQL command to do this
Note: See TracChangeset for help on using the changeset viewer.