I would appreciated if someone can help me with this problem: I am trying to update a datetime column (Received_Date) in a sql table using the following code: <cfquery datasource="databasesql" name="itemedit"> select * from item_master where id='#url.id#' </cfquery> <form action="updateditem.cfm" method="post"> <cfoutput query="itemedit"> <input type="text" name="Received_Date" size="30" maxlength="50" value='#Received_Date#'> </cfoutput> <input type="submit" value="Update Item"> </form> The updateditem.cfm code: <cfupdate datasource="databasesql" tablename="item_master" dbtype="ODBC" formfields="Received_Date"> When I enter a date 07/10/2000 ,the value does not get inserted in the table. There are other text columns in the form and all of them work fine but not the date. I don't want to enter a time even though it's a datetime column. Thanks for your help. ____________________________________________________________________ Get free email and a permanent address at http://www.netaddress.com/?N=1 ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
