CF defaults an empty field to an empty string not a NULL,
Use iif in the insert SQL to put in NULL if the field is not a date using
isDate() such as:
#iif(isDate(attributes.datefield), DE('###attributes.datefield ###'),
DE('NULL'))#
HTH,
Noam
----------
From: Carla Shafer [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, 14 December 2000 17: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
