From: comopasta Gr <granadojose@...>
Date: 2008-04-15T06:16:52+09:00
Subject: Storing arrays in db + model architecture

Hi,

My users can select items and define a quantity attribute for those.
Those items can be selected with checkboxes. And the quantity is a field
text.

Collecting all in one form; the checkbox selections, and other details,
the info should be stored in the db. Resulting in a purchase order for
example. A single user wouldn't have many purchase orders in the system
at one time.

My question is how to store the resulting array in the db? I know how to
get the array of values but what should I use as the container in the
db, a single row with a sting hash, store each item separately,
something else? How can I relate the quantity for each item?

The available items are not predefined, and users can create new items
into the system also.

I think it is pretty trivial stuff but I would like to get the models
and logic right from the beginning. Any good suggestions/tutorials?

Thanks.
-- 
Posted via http://www.ruby-forum.com/.