cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Antonio Gallardo Rivera <agalla...@agsoftware.dnsalias.com>
Subject dbAdd does not get correclty the param
Date Wed, 09 Oct 2002 20:06:46 GMT
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:     <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>


Mime
View raw message