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