Re: [GENERAL] Stroring html form settings

On Fri, 2008-09-26 at 09:23 -0700, Dianne Yumul wrote:

If the structure of each report did not differ this would work great 
but unfortunately it does.

Diane-

Would an EAV model work? I'm thinking something like <form,field,value>. For example:
formA,ckbox1,true
formA,input1,initial value
formB,textarea1,enter your long comment here

You could easily extend this to <user,form,field,value>, or normalize it as you see fit.

Another possibility is to use hstore hashes for form fields/values. See
http://www.postgresql.org/docs/8.3/static/hstore.html

Do either of those suffice?

-Reece

-- Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0