As you saw earlier in regards to inserting data, hard-coded SQL statements are neither flexible nor easy to maintain. ColdFusion provides a simpler way to update rows in database tables.
If you are using Windows 98 or ME and are using Microsoft Access, you won’t be able to use the <cfupdate> tag due to limitations with the Access database drivers on these platforms. You can still insert data using <cfquery> and update, and <cfupdate> will function correctly if you are using Access on Windows 2000, XP, or Vista.
The <cfupdate> tag is similar to the <cfinsert> tag discussed earlier in this chapter. <cfupdate> requires just two attributes—the data source and the name of the table to update—and supports an optional ...