I resolve the problem:
A stupid problem! I alone made it! I miss it:
values
validate dbcol=can_beneficiario param=beneficiario
^
Here is not validatre is value!
values
value dbcol=can_beneficiario param=beneficiario
Thanks to all ;)
Antonio Gallardo
El Miércoles, 09 de Octubre de 2002 14:06, Antonio Gallardo Rivera escribió:
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
connectionmp_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_idparam=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]
-
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]