--- /home/cvs/contributions/modules/casetracker/casetracker.module 2006-05-18 13:18:32.000000000 -0400 +++ casetracker.module 2006-05-18 13:34:10.000000000 -0400 @@ -2553,7 +2553,7 @@ array('data' => t('Case state name')), array('data' => t('Case state realm'))); $result = db_query("SELECT * FROM {casetracker_case_states}"); - $result1 = db_query("select distinct {case_state_realm} from {casetracker_case_states}"); + $result1 = db_query("select distinct case_state_realm from {casetracker_case_states}"); while ($row1 = mysql_fetch_array($result1)) { $field_values[$row1['case_state_realm']] = $row1['case_state_realm']; } @@ -2633,7 +2633,7 @@ '#required' => TRUE, '#default_value' => '', '#size' => 40); - $result = db_query("select distinct {case_state_realm} from {casetracker_case_states}"); + $result = db_query("select distinct case_state_realm from {casetracker_case_states}"); while ($row = mysql_fetch_array($result)) { $field_values[$row['case_state_realm']] = $row['case_state_realm']; }