Parameter
Last updated on
Apr 27, 2021
Description
Deletes all records in a query object.
Returns
An empty query object with all records deleted.
Category
Syntax
QueryClear(queryObject)
Member function
queryObject.Clear()
History
New in ColdFusion (2018 release) Update 5.
Parameters
|
|
Required/Optional |
Description |
|---|---|---|
|
queryObject |
Required |
The query object whose records are to be deleted. |
See also
Example
<cfscript>
myResult=QueryExecute("SELECT * FROM EMPLOYEES WHERE EMP_ID > 10",[],{datasource="cfdocexamples"});
WriteOutput("Original query object")
writedump(myResult)
// Query clear
QueryClear(myResult)
WriteOutput("After applying QueryClear")
writedump(myResult)
</cfscript>
Output
Original query object
After applying QueryClear
