Adobe ColdFusion 8 Web Application Construction Kit, Volume 1: Getting Started
by Ben Forta, Raymond Camden, Charlie Arehart
Introducing <cfupdate>
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.
Caution
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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access