I maybe way off here, what is the name of your form field?
If it is xxx_date then try renaming it to something else (anything except
*_date): I had an infuriating problem which boiled down to CF server side
validation (see CFWACK,p317)
Bert
ps theres a bug with CF date validation in that it allows dates that never
existed, eg 5th Sep 1752 - anyone had any problems with that one?
;)
> -----Original Message-----
> From: Carla Shafer [mailto:[EMAIL PROTECTED]]
> Sent: 14 December 2000 16:38
> To: Fusebox
> Subject: <cf_reuseform> and empty Date fields
>
>
> A longstanding problem I've had in using <cf_reuseform>
> (presently, with MS
> Access 2000) is that when I have an optional Date field that
> is empty at
> time of the data INSERT/UPDATE I get a "Data Type Mismatch"
> error. As long
> as a date was entered into the form, everything's hunky-dory.
> It's only
> when the field is submitted empty that the error occurs.
>
> I've checked to make sure the field is not required by the
> Access table. In
> fact, I can manually enter new records directly in the table
> and leave the
> field empty without having Access generate an error.
>
> I've tried using '#dateFormat()#', strings, numeric, formats in the
> act_saveForm template, all to no avail. After thinking for
> the last year or
> so that I would solve the problem on my own, it's now driving
> me crazy. I
> need the fields to be Null, so setting a default value is not
> an option.
>
> Anybody else ever run into this behavior?
>
>
> Carla J. Shafer, President/CEO
> Munex, Inc.
>
> .... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
> Munex is an Application Service Provider (ASP)
> and data warehousing service offering
> enterprise-scale applications to municipal
> governments across public and private networks.
>
> Find out more at http://www.munex.net
> The Municipal Information Exchange Munex Inc
> phone: 607 216-0906 PO Box 361
> fax: 708 575-8658 312 College Avenue
> ICQ: 6262998 Ithaca NY 14851-0361
> .... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
