sql queries in ruby on rails

Question

I have the following query that selects * where display in the Zips table is equal to a column in the users table.

This works fine, but how do I select ANOTHER column from the Zips table to print it out?

Zip.where(:display => @user.location)

So, for example the users table has a location col and the zips table has a display and zipcode column. I am finding the proper row by matching location from users to the display in zips but need to pull out zipcodes from the matching entry in zips...

Dylan Markow · Accepted Answer · 2011-05-01 23:59:08Z

1

Assuming your Zip table has the zipcode field:

@zips = Zip.where(:display => @user.location)
@zips.each do |zip|
  puts zip.zipcode
end

Or to put them in an array:

zipcodes = @zips.collect{ |zip| zip.zipcode }

In a view:

<h3>Zip Codes</h3>
<ul>
  <% @zips.each do |zip| %>
  <li><%= zip.zipcode %></li>
  <% end %>
</ul>

edited May 1, 2011 at 23:59

answered May 1, 2011 at 23:48

Dylan Markow

125k27 gold badges287 silver badges202 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

sql queries in ruby on rails

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related