You can either make the date a mandatory field or default the date to
today's date.
~Mark
-----Original Message-----
From: Ray, James A [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 02, 2000 2:06 PM
To: [EMAIL PROTECTED]
Subject: Date fields
I have an oracle table that is defined has a date field in it. When I allow
the user to enter information and they enter the date and save it,
everything goes great.
The problem is, when the user saves the record without entering the date. I
get an error. Before I save the data I do the following.
<cfif TRIM(Form.STOREAGEDATE) IS "">
<cfset FORM.STOREAGEDATE = " " > (I suspect the problem is
here)
<cfelse>
<cfset FORM.STOREAGEDATE = #DateFormat(FORM.STOREAGEDATE,
"dd-mmm-yy")#>
</cfif>
How do I save a date field without putting in a real date? I know I have
missed something in my reading.
Thank you
Jim Ray
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
