Displaying 3 results from an estimated 3 matches for "charge_name".
2006 Jul 14
3
compare two tables and find the difference?
...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 abou...
2006 Jul 17
0
collection_select help
...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</t...
2006 Jul 21
0
[Slightly OT] Need Query Help
...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.charge...