i'm trying to create a web app in rails which would allow an
administrator to setup a custom survey and allow users to fill-in the
survey. Sounds simple enough but how do you create a datastore
(presumably in mySQL) when you don't know the type of each question? So
you could have 3 multiple choice questions then 1 text box followed by
a date chooser.
My thoughts are:
a) use generic types - such as text or blob and limit the number of
b) generate the answers table upon completion of the the survey
structure - this then can't be edited (but unlikely to need editing
cause you can't change a survey after it's started anyway or you
wouldn't have a complete set of results).
I hope this is a generic enough question that the discussion will be
relevant to more than myself