Thanks Ian, Randy, and Michael! Your suggestions combined helped me. Now I understand (and better appreciate) using <cfqueryparam> especially since it also makes things more secure.
This line worked: <CFQUERYPARAM VALUE="#form.side1collectionsdate#" CFSQLTYPE="CF_SQL_VARCHAR" null="#yesNoFormat(NOT len(trim(form.side1collectionsdate)))#"> Robert O. -----Original Message----- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Thursday, January 27, 2005 1:06 PM To: CF-Talk Subject: RE: OT SQL date/time default That is probably your problem. I presume that form.formdate is a text field. And a empty text field is '' which is completely different then NULL. So you are inserting a value into the date field, a value of an empty string, but a value none the less. For situations like this and many other good reasons you should read up on the <cfqueryparam> tag. To fix your date issue trying changing this line ...'#form.formdate#', To <cfqueryparam value="#form.formdate#" cfsqltype="cf_sql_date" null="#yesNoFormat(NOT len(trim(form.formdate)))#"> Now looking at your code example, you seem to be inserting your date as a string, not a date? Is the field in the database a date field or a char|varchar field? PS you should change your other inserts to queryparams as well. -------------- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA "C code. C code run. Run code run. Please!" - Cynthia Dunning ...-----Original Message----- ...From: Robert Orlini [mailto:[EMAIL PROTECTED] ...Sent: Thursday, January 27, 2005 9:56 AM ...To: CF-Talk ...Subject: RE: OT SQL date/time default ... ...Ian, Randy, ... ...Just a plain insert and I fear that is the problem...only I don't work ...with CF enough to know the coding tips. ... ...Here it is below: ... ...<cfquery name="off" datasource="off"> ...Insert into off ...( ...formdate, ...admin, ...side1collectionsdate, ...side2collectionsdate, ...side3collectionsdate, ...side4collectionsdate, ...side5collectionsdate ...) ...VALUES ...( ...'#form.formdate#', ...'#form.admin#', ...'#form.side1collectionsdate#', ...'#form.side2collectionsdate#', ...'#form.side3collectionsdate#', ...'#form.side4collectionsdate#', ...'#form.side5collectionsdate#' ...) ...</cfquery> Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191984 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54