Re: storing survey answers of different data types

lawpoop wrote:

> Is there a
> 'best' way to solve this problem?

Yes, but no one ever seems to follow the advice. So before we use up any of our finite and dwindling lifetime typing it out for you, do you promise to follow the advice?

This is a programming problem not a database design problem. Even an SQL DBMS can handle this problem very easily. In fact this is, in miniature, exactly the kind of problem relational/SQL databases were conceived to solve. To apply the 'best' solution you will have to write one moderately complicated program that will read the database metadata but it will work for all future questionnaires. I am not being euphemistic or ironic--it will be only moderately complicated.

So, do you promise?

-- 
Roy