Storing and retrieving arrays in mysql using rails


#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:

On Fri, Mar 13, 2009 at 2:16 PM, vimal removed_email_address@domain.invalid
wrote:

Regards,
Vimal Das

Thanks & Regards,
Sumanth Krishna. A
+358 40 3276564

Blogs:
TwinclingCommunity:

http://sumanthtechsavvy.blogspot.com/
http://www.twincling.org/node/227

http://yourway2health.blogspot.com/
http://www.osef.twincling.org


#3

Cool suggestion :slight_smile:
Thanks! Sumanth