It still does not work.
descriptor:
<table-set name="pcm_contract">
<table name="pcm_contract" others-mode="attribute"/>
</table-set>
<table name="pcm_contract" alias="pcm_contract">
<keys>
<key name="id" type="int" autoincrement="true">
<mode name="auto" type="autoincr"/>
</key>
</keys>
<values>
<value name="contract_name" type="string"></value>
<value name="contract_type" type="int"></value>
<value name="contract_code" type="string"></value>
<value name="job_number" type="string"></value>
<value name="misc_code" type="string"></value>
<value name="start_date" type="date">
<mode name="datemeta" type="attrib">
<parameter>pcm_contract.start_date</parameter>
<format>MM/dd/yyyy</format>
<input-module name="request-param"/>
</mode>
</value>
<value name="end_date" type="date">
<mode name="datemeta" type="attrib">
<parameter>pcm_contract.end_date</parameter>
<format>MM/dd/yyyy</format>
<input-module name="request-param"/>
</mode>
</value>
<value name="contract_status" type="int"></value>
</values>
</table>
and the log is:
DEBUG (2003-02-19) 11:22.42:540 [sitemap]
(/pcm/contract_admin.contract.html) Thread-9/DefaultComponentFactory:
ComponentFactory creating new instance of
org.apache.cocoon.acting.modular.DatabaseUpdateAction.
DEBUG (2003-02-19) 11:22.42:541 [sitemap]
(/pcm/contract_admin.contract.html) Thread-9/DefaultComponentFactory: logger
attribute is sitemap.action.DatabaseUpdateAction
DEBUG (2003-02-19) 11:22.42:543 [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html)
Thread-9/AbstractComplementaryConfigurableAction: Using cached configuration
for contract_descriptor.xml
DEBUG (2003-02-19) 11:22.42:547 [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: modeTypes :
{2=request-attr, 1=others, 0=autoincr}
DEBUG (2003-02-19) 11:22.42:548 [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: i=0
DEBUG (2003-02-19) 11:22.42:549 [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: i=1
DEBUG (2003-02-19) 11:22.42:550 [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: i=2
DEBUG (2003-02-19) 11:22.42:551 [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: i=3
DEBUG (2003-02-19) 11:22.42:552 [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: i=4
DEBUG (2003-02-19) 11:22.42:553 [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: i=5
DEBUG (2003-02-19) 11:22.42:554 [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: i=6
DEBUG (2003-02-19) 11:22.42:555 [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: i=7
DEBUG (2003-02-19) 11:22.42:556 [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: i=8
DEBUG (2003-02-19) 11:22.42:557 [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: query: UPDATE
pcm_contract SET contract_name= ?, contract_type= ?, contract_code= ?,
job_number= ?, misc_code= ?, start_date= ?, end_date= ?, contract_status= ?
WHERE id= ?
DEBUG (2003-02-19) 11:22.42:558 [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Trying to set
column pcm_contract.id from request-param using getAttribute method
DEBUG (2003-02-19) 11:22.42:559 [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Setting column
pcm_contract.id [0] 17
DEBUG (2003-02-19) 11:22.42:560 [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Trying to set
column pcm_contract.contract_name from request-param using getAttribute
method
DEBUG (2003-02-19) 11:22.42:561 [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Setting column
pcm_contract.contract_name [0] Qwerty 123123
DEBUG (2003-02-19) 11:22.42:562 [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Trying to set
column pcm_contract.contract_type from request-param using getAttribute
method
DEBUG (2003-02-19) 11:22.42:563 [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Setting column
pcm_contract.contract_type [0] 1
DEBUG (2003-02-19) 11:22.42:564 [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Trying to set
column pcm_contract.contract_code from request-param using getAttribute
method
DEBUG (2003-02-19) 11:22.42:565 [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Setting column
pcm_contract.contract_code [0] QWERTY 123123
DEBUG (2003-02-19) 11:22.42:566 [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Trying to set
column pcm_contract.job_number from request-param using getAttribute method
DEBUG (2003-02-19) 11:22.42:566 [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Setting column
pcm_contract.job_number [0] ABC DEF
DEBUG (2003-02-19) 11:22.42:567 [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Trying to set
column pcm_contract.misc_code from request-param using getAttribute method
DEBUG (2003-02-19) 11:22.42:568 [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Setting column
pcm_contract.misc_code [0] 123123
DEBUG (2003-02-19) 11:22.42:569 [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Trying to set
column pcm_contract.start_date from request-param using getAttribute method
DEBUG (2003-02-19) 11:22.42:570 [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Setting column
pcm_contract.start_date [0] 02/03/2003
DEBUG (2003-02-19) 11:22.42:571 [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Trying to set
column pcm_contract.end_date from request-param using getAttribute method
DEBUG (2003-02-19) 11:22.42:572 [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Setting column
pcm_contract.end_date [0] 02/03/2003
DEBUG (2003-02-19) 11:22.42:573 [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Trying to set
column pcm_contract.contract_status from request-param using getAttribute
method
DEBUG (2003-02-19) 11:22.42:574 [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Setting column
pcm_contract.contract_status [0] 0
DEBUG (2003-02-19) 11:22.42:575 [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: ====> row no. 0
DEBUG (2003-02-19) 11:22.42:576 [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Setting column
pcm_contract.contract_name[0] to Qwerty 123123
DEBUG (2003-02-19) 11:22.42:577 [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Setting column
pcm_contract.contract_type[0] to 1
DEBUG (2003-02-19) 11:22.42:579 [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Setting column
pcm_contract.contract_code[0] to QWERTY 123123
DEBUG (2003-02-19) 11:22.42:580 [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Setting column
pcm_contract.job_number[0] to ABC DEF
DEBUG (2003-02-19) 11:22.42:582 [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Setting column
pcm_contract.misc_code[0] to 123123
DEBUG (2003-02-19) 11:22.42:583 [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Setting column
pcm_contract.start_date[0] to 02/03/2003
DEBUG (2003-02-19) 11:22.42:585 [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Rolling back
transaction. Caused by null
DEBUG (2003-02-19) 11:22.42:599 [sitemap]
(/pcm/contract_admin.contract.html) Thread-9/DefaultComponentFactory:
ComponentFactory decommissioning instance of
org.apache.cocoon.acting.modular.DatabaseUpdateAction.
Thanks for your help!
Andre
> -----Original Message-----
> From: Christian Haul [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 18, 2003 9:46 AM
> To: [EMAIL PROTECTED]
> Subject: Re: MySQL date conversion with modular database action
>
>
> Andre Taube wrote:
>
> <snip/>
>
> > Trying to set column pcm_contract.start_date from request-param using
> getAttribute method
> > Setting column pcm_contract.start_date [0] 2/9/2003
>
> This shows cleanly that you haven't requested the "attribute" mode here.
> Please check your table set!
>
> Chris.
>
> --
> C h r i s t i a n H a u l
> [EMAIL PROTECTED]
> fingerprint: 99B0 1D9D 7919 644A 4837 7D73 FEF9 6856 335A 9E08
>
>
> ---------------------------------------------------------------------
> 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]>
