Hi:
I am using dbAdd from the Original Database Actions. All my forms work very
well and I can add, update and remove records in a PostgreSQL. database.
But, I have a form that can add a register and it seems like after some
javascript change values in the form (based on what the user select on a
<select> tag). The dbAdd is not able to work with the parameters. I needed to
rename some of the params to meet the right name of the field into the
database.
For example: I before had a param called "id" and:
<key dbcol="can_id" mode="form" param="id" type="long"/>
But if I do that, then I got a error that the can_id can not be null (its
natural, but not normal), because I have into the form fixed the value for
"id":
<parameter name="id" value="1"/>
Then there is no way how "id" can be null!
Please help, me.
I am using Tomcat 4.1.12, Java 1.4.1, Cocoon -dev 2.1.
Antonio Gallardo
My descriptor.xml: ****************************************************
<root>
<parameter name="id" nullable="no" min="1" type="long"/>
<parameter name="cli_id" nullable="no" min="1" type="long"/>
<parameter name="can_estado" nullable="no" min="1" max="3" type="long"/>
<parameter name="usr_id" nullable="no" min="1" type="long"/>
<parameter name="beneficiario" nullable="no" min-len="3" max-len="50"
type="string"/>
<parameter name="metodo_entrega" nullable="no" min="1" max="3" type="long"/>
<parameter name="direccion" nullable="no" min-len="5" max-len="200"
type="string"/>
<parameter name="soc_id" nullable="no" min="1" type="long"/>
<parameter name="pre_id" nullable="no" min="1" type="long"/>
<parameter name="pre_nombre" nullable="no" min-len="3" max-len="50"
type="string"/>
<constraint-set name="update">
<validate name="id"/>
<validate name="cli_id"/>
<validate name="usr_id"/>
<validate name="can_estado"/>
<validate name="beneficiario"/>
<validate name="metodo_entrega"/>
<validate name="direccion"/>
<validate name="soc_id"/>
<validate name="pre_id"/>
<validate name="pre_nombre"/>
</constraint-set>
<constraint-set name="add">
<validate name="cli_id"/>
<validate name="usr_id"/>
<validate name="can_estado"/>
<validate name="beneficiario"/>
<validate name="metodo_entrega"/>
<validate name="direccion"/>
<validate name="soc_id"/>
<validate name="pre_id"/>
<validate name="pre_nombre"/>
</constraint-set>
<connection>mp_pool</connection>
<table name="canje">
<keys>
<key dbcol="can_id" mode="form" param="id" type="long"/>
<key dbcol="cli_id" mode="form" param="cli_id" type="long"/>
<key dbcol="usr_id" mode="form" param="usr_id" type="long"/>
<key dbcol="can_estado" mode="form" param="estado" type="long"/>
</keys>
<values>
<validate dbcol="can_beneficiario" param="beneficiario" type="string"/>
<validate dbcol="can_metodo_entrega" param="metodo_entrega"
type="long"/>
<validate dbcol="can_direccion_entrega" param="direccion"
type="string"/>
<validate dbcol="soc_id" param="soc_id" type="long"/>
<validate dbcol="pre_id"param="pre_id" type="long"/>
<validate dbcol="pre_nombre" param="pre_nombre" type="string"/>
<validate dbcol="pre_usd" param="dolares" type="string"/>
<validate dbcol="pre_millas" param="millas" type="long"/>
</values>
</table>
</root>
***********************************************************
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
