1) Can't you just require a date be entered for the form to go through?
2) If not, why not create a bogus/dummy date and insert that? Some date
faaaaar into the future or way in the past that will never get entered in
normal usage... in that way you could do queries looking for said date to
pull up records that users haven't entered legit dates on...
> -----Original Message-----
> From: Ray, James A [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 02, 2000 7: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/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
s/cf_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.