Changeset 16041 for gsdl/trunk
- Timestamp:
- 2008-06-17T17:09:38+12:00 (16 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
gsdl/trunk/src/lib/sqlitedbclass.cpp
r16039 r16041 202 202 } 203 203 204 // Get the raw "value" field unless a grouping expression was provided (in this case an edited value is returned) 205 text_t value_select_expression = "value"; 206 if (metadata_value_grouping_expression != "") 207 { 208 value_select_expression = metadata_value_grouping_expression; 209 } 210 204 211 // Get the entries in the "document_metadata" table where the element matches that specified 205 text_t sql_cmd = "SELECT DISTINCT docOID, valueFROM document_metadata WHERE element='" + sqlite_safe(metadata_element_name) + "'";212 text_t sql_cmd = "SELECT DISTINCT docOID," + value_select_expression + " FROM document_metadata WHERE element='" + sqlite_safe(metadata_element_name) + "'"; 206 213 207 214 // Add value filter, if one has been defined … … 211 218 } 212 219 220 // Perform the SQL request 213 221 vector<text_tmap> sql_results; 214 222 if (!sqlgetarray(sql_cmd, sql_results) || sql_results.size() == 0) … … 222 230 { 223 231 text_tmap sql_result = (*sql_results_iterator); 224 metadata_values.push_back(sql_result[ "value"]);232 metadata_values.push_back(sql_result[value_select_expression]); 225 233 sql_results_iterator++; 226 234 }
Note:
See TracChangeset
for help on using the changeset viewer.