Re: [GENERAL] Stroring html form settings

2008-09-26 Thread Dianne Yumul
Would an EAV model work? I'm thinking something like . For example: formA,ckbox1,true formA,input1,initial value formB,textarea1,enter your long comment here You could easily extend this to , or normalize it as you see fit. This would work great too. If we go this route, we'll keep it simpl

Re: [GENERAL] Stroring html form settings

2008-09-26 Thread Reece Hart
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 . For example: formA,ckbox1,true formA,input1,initial value formB,textarea1,en

Re: [GENERAL] Stroring html form settings

2008-09-26 Thread Martin Gainty
than intended recipient. Sender does not necessarily endorse content contained within this transmission. > From: [EMAIL PROTECTED] > Subject: Re: [GENERAL] Stroring html form settings > Date: Fri, 26 Sep 2008 09:23:21 -0700 > To: pgsql-general@postgresql.org > > First, I want to

Re: [GENERAL] Stroring html form settings

2008-09-26 Thread Dianne Yumul
which webserver does your client want to implement? Apache, sorry I forgot to mention. If JSLibrary = Dojo I would look at JSON (JavaScript Object Notation language) I would serialize to JSON instead of XML. http://www.aurore.net/projects/php-json/ A simple json_encode($_POST) might do th

Re: [GENERAL] Stroring html form settings

2008-09-26 Thread Dianne Yumul
First, I want to thank you for your help. You have made great points and I just want to respond to some of your questions. My first thought is that if you use a combined "info" field, you'll lose the ability to easily do any kind of meaningful data analysis based on which boxes are checked. I

Re: [GENERAL] Stroring html form settings

2008-09-26 Thread Marcus Engene
Dianne Yumul wrote: Hello, I have some html forms that I save the settings into the database, things like which item was selected in the menu and if a checkbox was checked. The table looks like this: user_id | report_id | info -+---+-

Re: [GENERAL] Stroring html form settings

2008-09-25 Thread Martin Gainty
which webserver does your client want to implement? if webserver is Apache does your client favor any JavaScript Library ? If JSLibrary = Dojo I would look at JSON (JavaScript Object Notation language) http://today.java.net/pub/a/today/2006/04/27/building-ajax-with-dojo-and-json.html if you wan

Re: [GENERAL] Stroring html form settings

2008-09-25 Thread Jeff Soules
On Thu, Sep 25, 2008 at 5:38 PM, Dianne Yumul <[EMAIL PROTECTED]> wrote: > Hello, > > I have some html forms that I save the settings into the database, things > like which item was selected in the menu and if a checkbox was checked. The > table looks like this: > > user_id | report_id |