Manipulating Information in the Database Using ColdFusion MX

You can use various operations to manipulate data in databases. One of these operations uses the <CFQUERY> tag and SQL statements, such as INSERT. Another method is to use ColdFusion tags, such as <CFINSERT>, without SQL statements. These tags were discussed in Chapter 4, “Form Handling Using ColdFusion MX,” in conjunction with the use of ColdFusion forms.

Some typical data manipulation functions are