Return-Path: Delivered-To: apmail-cocoon-users-archive@www.apache.org Received: (qmail 44504 invoked from network); 9 Jan 2008 13:51:04 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 9 Jan 2008 13:51:04 -0000 Received: (qmail 4156 invoked by uid 500); 9 Jan 2008 13:50:50 -0000 Delivered-To: apmail-cocoon-users-archive@cocoon.apache.org Received: (qmail 4102 invoked by uid 500); 9 Jan 2008 13:50:50 -0000 Mailing-List: contact users-help@cocoon.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: Reply-To: users@cocoon.apache.org List-Id: Delivered-To: mailing list users@cocoon.apache.org Received: (qmail 4091 invoked by uid 99); 9 Jan 2008 13:50:50 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 09 Jan 2008 05:50:50 -0800 X-ASF-Spam-Status: No, hits=2.0 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [146.64.10.166] (HELO wabe.csir.co.za) (146.64.10.166) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 09 Jan 2008 13:50:32 +0000 Received: from cs-emo.csir.co.za (cs-emo.csir.co.za [146.64.10.40]) by wabe.csir.co.za (8.14.1/8.14.1) with ESMTP id m09DnpPt005178 for ; Wed, 9 Jan 2008 15:49:55 +0200 Received: from GW-EMO-MTA by cs-emo.csir.co.za with Novell_GroupWise; Wed, 09 Jan 2008 15:49:50 +0200 Message-Id: <4784ED0A.5CE9.00D4.0@csir.co.za> X-Mailer: Novell GroupWise Internet Agent 7.0.2 HP Date: Wed, 09 Jan 2008 15:49:30 +0200 From: "Derek Hohls" To: Subject: MySQL "Year" vs CForms "Date" Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="=__Part81A74FFA.0__=" X-CSIR-MailScanner-Information: Please contact sys-admin at csir dot co dot za for more information X-CSIR-MailScanner: Found to be clean X-MailScanner-From: dhohls@csir.co.za X-Virus-Checked: Checked by ClamAV on apache.org --=__Part81A74FFA.0__= Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Running Cocoon 2.1.8. =20 I am trying to get a database submission to work with Cocoon Forms.=20=20 Up to now, all the data types have mapped well to the database column types. However, now that I am trying to use the MySQL "Year" column type, I have run into a problem. The Cocoon Forms definition validator=20 will not accept an "integer" type and, if I set the type to "date", then an entry containing just a year value (e.g. 2007) is not accepted as a=20 proper date. How can I resolve this impasse between the two systems? =20 Thanks Derek =20 --=20 This message is subject to the CSIR's copyright terms and conditions, e-mai= l legal notice, and implemented Open Document Format (ODF) standard.=20 The full disclaimer details can be found at http://www.csir.co.za/disclaime= r.html. This message has been scanned for viruses and dangerous content by MailScan= ner,=20 and is believed to be clean. MailScanner thanks Transtec Computers for the= ir support. --=__Part81A74FFA.0__= Content-Type: text/html; charset=US-ASCII Content-Transfer-Encoding: quoted-printable

Running Cocoon 2.1.8.

I am trying to get a database submission to work with Cocoon Forms.&nb= sp;

Up to now, all the data types have mapped well to the database column<= /DIV>

types. However, now that I am trying to use the MySQL "Year" col= umn

type, I have run into a problem. The Cocoon Forms definition val= idator

will not accept an "integer" type and, if I set the type to "date= ", then

an entry containing just a year value (e.g. 2007) is not accepted= as a

proper date. How can I resolve this impasse between th= e two systems?

Thanks

Derek

--=20
This message is subject to the CSIR's copyright terms and conditions,= e-mail legal notice, and implemented Open Document Format (ODF) standard.
The full disclaimer details can be found at http://www.csir.co.za/disclaimer.html.

This message has been scanned for viruses and dangerous content by MailScanner,=20
and is believed to be clean. MailScanner thanks Transtec Computers for their support. --=__Part81A74FFA.0__=--