http://livedocs.adobe.com/ Macromedia LiveDocs - online documentation with user feedback. Copyright 2009, Macromedia, Inc. 2009-11-25T17:22:33 en-us http://livedocs.adobe.com/coldfusion/7/htmldocs/00001261.htm#31197 Good catch. The correct SQL (in the procedure and the code review) should be something like:<br><br>UPDATE Employee<br> SET FirstName = '#Form.Firstname#',<br> LastName = '#Form.LastName#',<br> Dept_ID = #Form.Dept_ID#,<br> StartDate = '#left(Form.StartDate,19)#',<br> Salary = #Form.Salary#,<br> Contract = '#Form.contract#'<br> WHERE Emp_ID = #Form.Emp_ID#<br><br>I have added doc bug 60054 to help us track this issue. jrunrandy 1 1 2005-04-11T12:59:47 http://livedocs.adobe.com/coldfusion/7/htmldocs/00001261.htm#30716 Why doesnt the cfquery example show you the checkbox update in the SQL?<br /><br />The way this shows at the moment, the update form won't update the contractor field so this is a poor example. Please can this be rectified to show how to update the contractor field via the checkbox?<br /><br />Thanks jedimatt 0 0 2005-03-31T04:47:31