Actually, this might be better depending on where and how you're doing your
validation:
<cfif len(trim(attributes.date))>
-----Original Message-----
From: Richmond, Alan
Sent: Thursday, December 14, 2000 10:14 AM
To: '[EMAIL PROTECTED]'
Subject: RE: <cf_reuseform> and empty Date fields
Have you tried not inserting it? Just skip over it if the form field is
empty.
<cfif attributes.date NEQ ''>
--date update or insert SQL--
</cfif>
-----Original Message-----
From: Carla Shafer [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 14, 2000 9:38 AM
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
