Displaying 3 results from an estimated 3 matches for "charge_ids".
Did you mean:
charge_id
2006 Jul 14
3
compare two tables and find the difference?
I need to compare a column in TableA to a column in TableB and then
select 3 columns from TableA for all the records in TableA that don''t
exist in TableB.
TableA and 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
2006 Jul 21
0
[Slightly OT] Need Query Help
I need to select 1 record from each client. This record has the charge
with the most severe charge type (lowest charge_type_id). How do I go
about this?
I have been using a find_by_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
2008 Mar 12
2
Building a view for a 3 model has_many relationship
...I can
enter the hours and those then get posted to my budget_plan model
otherwise they just remain blank.
I''m doing something similar in another view that works fine with a habtm
relationship:
<% for charge in @charges %>
<div>
<p>
<%= check_box_tag "user[charge_ids][]", charge.id,
@user.charges.include?(charge) %>
<%= [charge.project_number, charge.primary_number].join('''') %> - <%=
charge.label %>
</p>
</div>
<% end %>
That is used to determine which charges a user has access to, so when on
the...