[Rails] Re: Trying to do a report with a list of zip codes and getting stuck..

2010-09-10 Thread Bob Smith
On Sep 10, 11:52 am, Philip Hallstrom phi...@pjkh.com wrote: 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

[Rails] Re: Trying to do a report with a list of zip codes and getting stuck..

2010-09-09 Thread Bob Smith
On Sep 10, 12:41 am, 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