Hi Mika,

not sure if I completely understood your question. By stating "my forms are created dynamically based on data in database" you mean to say that form elements values constitute the dynamical aspect of the form (thus the data) or do you mean to say the form element themselves are changing based upon data that is received. Thus, suppose you would be dealing with a form for car information. The form has e.g. form element for entering the license plate number. This form element could be say a simple input form element of type text for one set of data, while for another data set the same input is now an text area?

Best,
André

On 03/28/2012 10:34 AM, m...@digikartta.net wrote:

Suggesting to myself:
Modular Database Actions?
Right?

On Tue, 27 Mar 2012 22:50:56 +0300, Mika M Lehtonen <m...@digikartta.net> wrote:
Hi,
what is the right and the proper way of inserting  form data to
database table (PostgreSQL)?
What makes this more "interesting" is that instead of horizontal data
in table, the data is stored in a vertical manner because of the
highly dynamic nature of the application and the relation model. That
is, my forms are created dynamically based on data in database. In the
same way, the values shoud be stored vertically, because the the table
structure would otherwise have to vary based on form types and
eventually I would have hundreds of different tables.

I have done some testing with XSP and ESQL in order to retrieve my
forms. That works fine, although if I have understood right, XSPs'
aren't recommended to use, am I right?

But now I would have to insert form values to another table
vertically (different columns for different datatypes). How should I
approahce the challenge? Any thoughts?

Sorry if I am asking entirely obvious questions. I don't have such a
long experience with the Cocoon. Testing things now with the 2.11 and
am going to shift to 2.2, even 3.0 some day later or sooner. Also
coming more from .NET side.. forgive me..

- mika -


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@cocoon.apache.org
For additional commands, e-mail: users-h...@cocoon.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@cocoon.apache.org
For additional commands, e-mail: users-h...@cocoon.apache.org



--
Andre H. Juffer              | Phone: +358-8-553 1161
Biocenter Oulu and           | Fax: +358-8-553-1141
Department of Biochemistry   | Email: andre.juf...@oulu.fi
University of Oulu, Finland  | WWW: www.biochem.oulu.fi/Biocomputing/
StrucBioCat                  | WWW: www.strucbiocat.oulu.fi
Triacle Biocomputing         | WWW: www.triacle-bc.com


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@cocoon.apache.org
For additional commands, e-mail: users-h...@cocoon.apache.org

Reply via email to