similar to: Undefined method updated? for <model object>

Quick question. Say I have a geographical database with counties and zip codes where counties have and belong to many zip codes. zip_codes (id, zip_code) counties (id, name) When I create the association table, the Rails way says to do the following: counties_zip_codes (county_id, zip_code_id). However, given that zip_codes.zip_code is itself a candidate key, I would much prefer to do the

Hi all - I posted yesterday with the subject "namespace pollution" and with the high traffic on this list, it''s kind of disappeared and I''m in need of a quick answer so i can move on. To recap quickly, can someone tell if Rails is somehow forcing all modules into a single namespace? I have a model class StateProvince and inside a webservice module in my lib/

I want to convert following query into pure ruby one i.e. by using find @us_state_sales=SalesReport.find_by_sql("SELECT z.state, sum(s.royalty_price) as royalty_price, sum(s.units) as units FROM sales_reports s, zip_codes z WHERE royalty_currency = ''USD'' && z.zip_code=s.postal_code GROUP BY z.state ORDER BY royalty_price desc LIMIT 10") i try something like

Description: ========= This is a fairly simple but handy plugin that lets you specify which database connection to use on a per-model basis. It is useful when you have multiple applications sharing the same data, in other words, this is just a nicer way of using “Model.establish_connection(database)”. Example: ======= First create a ‘shared’ database configuration in config/database.yml: shared:

I cant seem to find much information apart from the basics on transactions in rails. I have 5 nested transactions, and am performing the following basic operations: @whatever1.transaction do @whatever2.transaction do .... @whatever2.something = "foo" @whatever1.something = "bar" @whatever1.save @whatever2.save ..... end end ((( I had tried using

Hey all, I''m rather new to Ruby and Rails (and not great with SQL), but I''m developing a ride sharing app and would like to be able to sort on something I don''t have stored. I have users, events, and rides, each of which has a zip code. Events have_many rides, and rides belong_to events. When an event is selected, I''d like to be able to show a list of

I am regularly running into a problem where I can't seem to figure out how maintain correct data order when selecting data out of a dataframe. The below code shows an example of trying to pull data from a dataframe using ordered zip codes. My problem is returning the pulled data in the correct order. This is a very simple example, but it illustrates a regular problem that I am running into.

i've search the email archives, searched the documention of various map packages and done an R-site search, but have been unable to find direct resources for creating maps of the US that are colored or annotated or ... by zipcode data. For example, create a map of the US and color each zipcode region by its population using two vectors z,p containing the zipcode and population,

I am interested in locating a script to implement a sampling scheme that would basically make it more likely that a particular observation is chosen based on a weight associated with the observation. I am trying to select a sample of ~30 census blocks from each ZIP code area based on the proportion of women in a ZCTA living in a particular block. I want to make it more likely that a block will

Please help me solve the following error message: syntax error, unexpected tINTEGER, expecting $end I have this model: Code: 1. class GeoDatum < ActiveRecord::Base 2. end The database contains the table geo_data, which contains the zip_code column, filled with zip codes. I get the above error when searching for a zip code and the zip code exists in the table. Here is the

Dear R-Users, Suppose I have data in the following format: CODE_NAME ZIP_CODE John 12345 John 23456 John 34567 Jane 13242 Jane 22123 I want to transpose / convert it into: CODE_NAME ZIP_CODE John 12345,23456,34567 Jane 13242,22123 Any idea/pointer is appreciated.

Is there any package that I could use for zipcode search. I want to display schools that near a particular zipcode. I have no idea how to do this. It will be great if anyone can point me where I could find info -- Rgds, --Siva Jagadeesan http://www.varcasa.com/ Education Through Collabration -------------- next part -------------- An HTML attachment was scrubbed... URL:

I need to write a method for calculating the fee for medical procedures with respect to area. I have all the tables and data but its hard to give that here. Can someone take a look at this ''stub'' method and help me out? def calculate_fee # strip out the first 3 numbers of the user entered zip code # use those 3 numbers to identify row in [zipcodes table] (between upper and

I have two objects, QuoteInput and Insured. QuoteInput has one Insured and Insured belongs to QuoteInput. I don''t understand what I''m seeing. I assign an Insured to a QuoteInput. The Insured object has invalid data. I call save! on the quote input. QuoteInput has no validations. I expect two things to happen - 1) an exception should be thrown, indicating that there was a

Hi There, I''m trying to user fields_for inside a form_tag, but i can''t catch it on my controller. I just take some html code off to makes it easy to read my view... i''m using campuses_path(current_church, @campus) instead form_for @campus, because my route is like resources :campuses, :path => ":church/campuses" <%= form_tag

This is a stupid question I know, but it is driving me crazy - I am missing something simple and basic here. I am trying to update missing zip codes on a data table. I am doing something incorrectly as the data in the Source table is not being updated, only the value in the array is changed. How do I get this to update the actual DB record instead? def add_missing_zips #find all records in

Hey, Does anybody know of a good Geocode library for Ruby, similar to Perl''s Geocode::Postal, that i could use in my rail app? I need to do some "within 5 miles" calculations of zipcodes and i dont have a nice ruby (or gem) utility to do it. any help would be appreciated. thanks adam _______________________________________________ Rails mailing list

I''m stuck in a catch-22 type problem. I have an insert form for a table that uses the validation in the model. i.e. When you click submit on the form and haven''t filled in the required fields then you get the nice rails error messages saying "field can not be blank". This works fine until I introduce some more logic. What I''m trying to do is to validate

I'm working with some data, and am trying to generate it in the following format. state city zipcode I like pizza 0 0 0 I live in Denver 0 1 0 All the fun stuff is in Alaska 1 0 0 he lives in 66062

I have a an STI table which acts_as_tree, that has a large number of classes/types. My common fields are: id parent_id name description with 4 more text fields, I could cover most of my classes if I could redefine the name of the field like this. text1 AS address1 text2 AS address2 text3 AS zipcode For one class and text 1 AS model_number text2 AS vendor Is there a construct that will allow