On 10 September 2010 05:41, Bob Smith <bsm...@gmail.com> wrote: > I'm trying to get a list of zip codes in my database with > > zipstring = sprintf("select distinct zip from visits,households where > " + > "households.id=visits.household_id and visits.month='%2d' and > visits.year = '%4d' " + > "and visits.monthly = 1 order by households.zip;", datestart.month, > datestart.year, dateend, datestart) > > @ziplist = Household.find_by_sql(zipstring) > > this gives me an array of zip codes. Then I use > > <%= render :partial=>"monthly_report", :collection => @ziplist %> > > to run monthly_report for each zip code. This is where the problem is. > If I try to put the variable into a find call, it isn't text. > > If I look at it in the debugger, it's > > #<Household zip: "01501"> > > and .to_s is > > "#<Household:0xb68ad9e4>" > > All I need is the 01501 part, but I'm getting the memory address in my > find call. Please help.
Can you not just use .zip on each element to get what you want? Colin -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-t...@googlegroups.com. To unsubscribe from this group, send email to rubyonrails-talk+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.