Storing and retrieving arrays in mysql using rails

[casper_the_ghost]

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

[casper_the_ghost]

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

On Fri, Mar 13, 2009 at 2:16 PM, vimal [email protected]
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

[casper_the_ghost]

Cool suggestion
Thanks! Sumanth