Database Manipulation Tags

namedescription
cfdbinfoLets you retrieve information about a data source, including details about the database, tables, queries, procedures, foreign keys, indexes, and version information about the database, driver, and JDBC.
cfinsertInserts records in data sources from data in a ColdFusion form or form Scope.
cfobjectcacheFlushes the query cache.
cfprocparamDefines stored procedure parameters. This tag is nested within a cfstoredproc tag.
cfprocresultAssociates a query object with a result set returned by a stored procedure. Other ColdFusion tags, such as cfoutput and cftable, use this query object to access the result set. This tag is nested within a cfstoredproc tag.
cfqueryPasses queries or SQL statements to a data source.
cfqueryparamVerifies the data type of a query parameter and, for DBMSs that support bind variables, enables ColdFusion to use bind variables in the SQL statement. Bind variable usage enhances performance when executing a cfquery statement multiple times.
cfstoredprocExecutes a stored procedure in a server database. It specifies database connection information and identifies the stored procedure.
cftransactionFor enterprise database management systems that support transaction processing, instructs the database management system to treat multiple database operations as a single transaction. Provides database commit and rollback processing. See the documentation for your database management system to determine whether it supports SQL transaction processing.
cfupdateUpdates records in a data source from data in a ColdFusion form or form Scope.