Re: UPDATE column with NULL values?
If the field is not required try Set column_name = '' -- Original Message -- From: "Christian N. Abad" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Mon, 02 Apr 2001 13:43:49 -0400 Hey, Folks! I'm having difficulty updating a Date/Time column in an Access db. When I attempt to execute this SQL in a tag, I receive the following error : SQL : UPDATE table_name SET column_name = NULL ERROR : ODBC Error Code = 22005 (Error in assignment) [Microsoft][ODBC Microsoft Access Driver]Invalid character value for cast specification (null) QUESTION : Does anyone know how to update a Date/Time column with NULL values using ODBC and Access? Thanks! Christian N. Abad ColdFusion Developer ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: UPDATE column with NULL values?
I'd like to know the answer to this one too - I've been using 1-1-1900 and testing the date col with LT or GT where I need to, but there must be an easier way (?). -Original Message- From: Christian N. Abad [mailto:[EMAIL PROTECTED]] Sent: 02 April 2001 18:44 To: CF-Talk Subject: UPDATE column with NULL values? Hey, Folks! I'm having difficulty updating a Date/Time column in an Access db. When I attempt to execute this SQL in a tag, I receive the following error : SQL : UPDATE table_name SET column_name = NULL ERROR : ODBC Error Code = 22005 (Error in assignment) [Microsoft][ODBC Microsoft Access Driver]Invalid character value for cast specification (null) QUESTION : Does anyone know how to update a Date/Time column with NULL values using ODBC and Access? Thanks! Christian N. Abad ColdFusion Developer ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: UPDATE column with NULL values?
Hey, Folks... I was able to figure this one out. (It actually was working, but I was looking at the incorrect code...) So, this one is solved. Thanks, Christian "It's Monday" Abad ColdFusion Developer -Original Message- From: Christian N. Abad [mailto:[EMAIL PROTECTED]] Sent: Monday, April 02, 2001 1:44 PM To: CF-Talk Subject: UPDATE column with NULL values? Hey, Folks! I'm having difficulty updating a Date/Time column in an Access db. When I attempt to execute this SQL in a tag, I receive the following error : SQL : UPDATE table_name SET column_name = NULL ERROR : ODBC Error Code = 22005 (Error in assignment) [Microsoft][ODBC Microsoft Access Driver]Invalid character value for cast specification (null) QUESTION : Does anyone know how to update a Date/Time column with NULL values using ODBC and Access? Thanks! Christian N. Abad ColdFusion Developer ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists