Saving multiple select form data in db

Posted by fl00r on Stack Overflow See other posts from Stack Overflow or by fl00r
Published on 2010-05-08T19:40:34Z Indexed on 2010/05/08 19:48 UTC
Read the original article Hit count: 183

Filed under:

serializing

|

ruby-on-rails

|

ruby

|

activerecord

Hi.

I've got form for some model A, which has got few fields:

tile
description
...
colors

colors are selected from multiple select and options are ['red', 'green', 'blue', 'yellow']. User can choose colors as many as he wants. I don't think that making Color model and has_many relationship is good solution here to store colors data in model A. So question is:

How to store multiple data in db for such multiple select forms?

© Stack Overflow or respective owner

Related posts about serializing

Using Microsoft's Chart Controls In An ASP.NET Application: Serializing Chart Data

as seen on Internet.com - Search for 'Internet.com'
This article, by Scott Mitchell, shows how to store (and load) the data generated by the Microsoft Chart Controls to disk or some other store. >>> More
Using Microsoft's Chart Controls In An ASP.NET Application: Serializing Chart Data

as seen on Internet.com - Search for 'Internet.com'
This article, by Scott Mitchell, shows how to store (and load) the data generated by the Microsoft Chart Controls to disk or some other store. >>> More
Using Microsoft's Chart Controls In An ASP.NET Application: Serializing Chart Data

as seen on 4 Guys From Rolla - Search for '4 Guys From Rolla'
In most usage scenarios, the data displayed in a Microsoft Chart control comes from some dynamic source, such as from a database query. The appearance of the chart can be modified dynamically, as well; past installments in this article series showed how to programmatically customize the axes, labels… >>> More
Using Microsoft's Chart Controls In An ASP.NET Application: Serializing Chart Data

as seen on Internet.com - Search for 'Internet.com'
This article, by Scott Mitchell, shows how to store (and load) the data generated by the Microsoft Chart Controls to disk or some other store. >>> More
Using Microsoft's Chart Controls In An ASP.NET Application: Serializing Chart Data

as seen on Internet.com - Search for 'Internet.com'
In most usage scenarios, the data displayed in a Microsoft Chart control comes from some dynamic source, such as from a database query. The appearance of the chart can be modified dynamically, as well; past installments in this article series showed how to programmatically customize the axes, labels… >>> More

Related posts about ruby-on-rails

Ruby on Rails - How can I start? [closed]

as seen on Programmers - Search for 'Programmers'
I have misconception in understanding the relationship between Ruby language and Ruby on Rails Framework. Because of 'I am an absolute beginner' in web development I have no idea if I have to grasp the fundamentals of Ruby before I go with Ruby on Rails! I also want to ask who is behind both Ruby… >>> More
DES3 decryption in Ruby on Rails

as seen on Stack Overflow - Search for 'Stack Overflow'
My RoR server receives a string, that was encrypted in C++ application using des3 with base64 encoding The cipher object is created so: cipher = OpenSSL::Cipher::Cipher::new("des3") cipher.key = key_str cipher.iv = iv_str key_str and iv_str: are string representations of key and initialization… >>> More
Ruby on rails: Image downloads with Authentication/Authorization/Time outs

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi Guys, I'm having few doubts on implementing file downloads. I'm creating an app where I use attachment_fu with Amazon s3 to upload files. Things are working pretty well so far on uploading side. Now its the time to start the file downloads. Here is what I need, a logged in user search and browse… >>> More
Ruby on Rails deployment, on "thin" server with lot of attachments

as seen on Stack Overflow - Search for 'Stack Overflow'
A lot of PDFs are stored inside MySQL as a BLOB field for each PDF file. The average file size is 500K each. The Rails app will stream the :binary data as file downloads, where there is a user click on the download link. Assume there is a maximum of 5 users downloading 5 PDFs concurrently, what… >>> More
Apply Behavior Driven Development to Ruby on Rails with Rspec

as seen on Internet.com - Search for 'Internet.com'
Applying the Behavior Driven Development (BDD) methodology to your Rails development takes you beyond traditional Test Driven Development. Learn how to do it with the Ruby-based BDD framework RSpec. >>> More