storing and retrieving arrays in mysql using rails

rubyonrails-talk
1

Hi,

  I have a multiple checkbox of values 1 to 7 for selecting weekdays.

  What is the possibility of storing the selected weekdays array in mysql   and what type of field should i create in the table for storing the array.   Any suggestions???

Regards, Vimal Das

2

Interesting, nothing extra tweaks are required to achieve this.

<%= select_tag "days[]", options_for_select([ "Mon", "Tue", "Wed", "Thu","Fri","Sat","Sun",], "Monday"),:multiple => true %>

This would ensure that your selection is stored into array “days”. You can store this as string into db with a delimiter of your choice [preferably days.join(“,”)].

hope it was useful, else post me more details :slight_smile:

3

Cool suggestion :slight_smile: Thanks! Sumanth