Parameter
Senast uppdaterad den
2 maj 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