Multiple select

Is it possible to save multiple select values into one table sell?

Option A Option B Option C Option D

I know, there should be two tables, but… there is 3 miljons rows in
table and 99% of rows has only one select value…

So is it possible to make something like this:

data (id, name, select)

1, “xxxx”, “A”
2, “xxxx”, “B”
2, “xxxx”, “A,B”

Some “hack” to forms and controller?

On 11 December 2011 08:59, Fresh M. [email protected] wrote:

table and 99% of rows has only one select value…

So is it possible to make something like this:

data (id, name, select)

1, “xxxx”, “A”
2, “xxxx”, “B”
2, “xxxx”, “A,B”

Some “hack” to forms and controller?

Forget about forms and controllers initially, just think about how to
store the data in the database. The rest can come later. One option
would be use a bit field for the selections, so A would be represented
by binary 001, B by 010, C by 100 and so on, then for A and B the
value would be 011. I believe there are gems available that will
handle this for you though I have not used them. Google for
rails bitfield
shows a number of hits that look useful.

Colin

Hi all

I’m hoping to play around with Rails and Adhearsion but I find it very
hard to get started. Does anybody know about a good starting point on
the web or perhaps an example application code, perhaps on git?

Thanks in advance

Binni

ITAnet
Kirkestien 20
9230 Svenstrup

Telefon: 3020 0868

Email: [email protected]
WWW: http://www.itanet.nu

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs