search for: charge_nam

...nd TableB are different but do have one field in common that i am comparing. The tables are not related in anyway. right now I have a find_by_sql query located in a model that looks like this: def self.absent_charges find_by_sql <<-QUERY SELECT sources.charge_id_number, sources.charge_name, sources.offense_level FROM sources LEFT JOIN charges ON sources.charge_id_number = charges.charge_id_number WHERE charges.id IS NULL QUERY end I also need to dedupe what ends up in my final collection after the find_by_sql query, but I am not sure how to go abo...

...m i doing wrong? any suggestions? I have also tried: <%= collection_select "charge", "offense_level", @charge_types, :id, :full_name %> but that doesn''t work either. @charges contains multiple records obtained from a find_by_sql query. each record has 3 fields: charge_name, charge_id_number, offense_level @charge_type.id should be equal to the @charge.offense_level the view - update_charges.rhtml: <h2>Add missing records to charges table</h2> <%= start_form_tag %> <table> <th>Charge id number</th> <th>Charge name</...

...sql query out of the client.rb that looks like: SELECT c.f_name AS f_name, c.l_name AS l_name, c.gender AS gender, c.race AS race, c.dob AS dob, c.address AS address, c.city AS city, c.state AS state, c.zipcode AS zipcode, m.date_of_arrest AS date_of_arrest, ch.name AS charge_name, t.classification AS charge_type, t.classification_level AS charge_level, t.max_fine AS max_fine, t.min_jail_time AS min_jail, t.max_jail_time AS max_jail FROM clients AS c LEFT JOIN matters AS m ON c.id = m.client_id LEFT JOIN charges AS ch ON m.charg...