Thanks, that's exactly what I need. However, my date is in MM/dd/YYYY
format, how could I pass a format string to the DateMetaInputModule? API
says: "Configuration options: child element "input-module" holds InputModule
to obtain the string from, attribute "format" to "input-module" that holds a
java.text.SimpleDateFormat format string"
but the following does not work for me:
<value name="start_date" type="date">
<!-- if "attrib" is requested, convert string to a Date using the
date conversion module -->
<mode name="datemeta" type="attrib">
<!-- pass the following as attribute name to the nested module -->
<parameter>start_date</parameter>
<!-- use the request parameter module to obtain the string -->
<input-module name="request-param" format="MM/dd/YYYY"/>
</mode>
</value>
> -----Original Message-----
> From: Christian Haul [mailto:[EMAIL PROTECTED]]
> Sent: Monday, February 17, 2003 12:54 AM
> To: [EMAIL PROTECTED]
> Subject: Re: MySQL date conversion with modular database action
>
>
> On 15.Feb.2003 -- 01:44 AM, Andre Taube wrote:
> > Any pointers on how to convert a date before it's inserted into MySQL
> > database while using cocoon's Modular Database Action?
> >
> > I tried
> >
> > <value name="start_date" type="date">
> > <mode name="attribute"
> >
> parameter="org.apache.cocoon.components.modules.input.DateMetaInpu
> tModule:start_date[0]"
> > type="attrib"/>
> > </value>
> >
> > It seems this "mode" parameter is being ignored.
>
> Hi. You don't include all involved configuration lines so let's
> analyse only the above mode element:
>
> @name -> use the input module known as "attribute". This used to be
> the one operating on request attributes. This has been
> renamed to "request-attr" for default configurations.
> Make sure there is an input modules with short-hand
> "attribute"!
>
> @parameter -> interpretation depends on the input module used. Not all
> modules accept this parameter. For the request attribute
> module, this is the name of the request attribute to use
> instead of the one actually passed to the getAttribute()
> method. The default name generated by the database
> actions is
> "table.column"
> Make sure that this attribute exists and contains a
> compatible value!
>
> @type -> By placing XML-attributes "others-mode" or
> "autoincrement-mode" to the <table/> elements inside the
> <table-set/> elements, different modes can be
> selected. This
> mode is only used when the table in the table-set has the
> XML-attribute others-mode="attrib"
> Make sure that this is the case!
>
> But I reckon that you really wanted to write
>
> <value name="start_date" type="date">
> <!-- if "attrib" is requested, convert string to a Date using the
> date conversion module -->
> <mode name="datemeta" type="attrib">
> <!-- pass the following as attribute name to the nested module -->
> <parameter>start_date</parameter>
> <!-- use the request parameter module to obtain the string -->
> <input-module name="request-param"/>
> </mode>
> </value>
>
> or the like.
>
> BTW if you were using a recent snapshot (of either branch), then you
> might not need to convert a string to a date if it is a valid SQL date
> representation.
>
> 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]>
