If the Contractor check box is unchecked, no value is passed to the action page; however, the database field must have some value. The SQL UPDATE statement is more flexible for complicated updates. The following procedure assumes that you have created the update_page as described in Creating an update action page with cfupdate. The easiest way to designate the primary key in an update form is to include a hidden input field with the value of the primary key for the record you want to update.The hidden field indicates to Cold Fusion which record to update. This example does not use Cold Fusion formatting functions.
How do I UPDATE the table in Coldfusion to accept a NULL value.Here is my Query: Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.You can also add some simple debugging like writing to a file to log the executed attempt?One thing that stands out to me: Should the I don't use cfupdate or cfinsert, but I don't think any cf flavor supports the syntax you're trying to use, which leads me to believe it's an easy mistake.