Remove the single quotes around #createODBCDate(Now())# ..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com
-----Original Message----- From: Imperial, Robert [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 30, 2007 12:21 PM To: CF-Talk Subject: need help with updating date field I know this is probably obvious to most of you here, but I have an error on an update statement that I need some enlightenment on please. I'm using MSSQL2k, CFMX7 and I have an insert statement that works fine using "#createODBCdate(Now())#" but my update bombs on it?? Here's my update: UPDATE AdminPersonnel SET First_Name = '#form.First_Name#', Last_Name = '#form.Last_Name#', MI = '#form.MI#', Division = '#form.division#', Degree = '#form.Degree#', Title = '#form.Title#', Email = '#form.Email#', Phone = '#form.Phone#', Fax = '#form.Fax#' Date = '#createODBCdate(Now())#', IPAddress = '#CGI.REMOTE_ADDR#' WHERE ID = #form.ID# And here is the error Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'Date'. The error occurred in D:\WebNew\domis\admin\actUpdateAdminPersonnel.cfm: line 16: line 1 Called from D:\WebNew\index.cfm: line 17 14 : Date = '#createODBCdate(Now())#', 15 : IPAddress = '#CGI.REMOTE_ADDR#' 16 : WHERE ID = #form.ID# 17 : </cfquery> Awaiting your enlightenment ;) Bob ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279586 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
