QueryClear

Description

Deletes all records in a query object.

Returns

An empty query object with all records deleted.

Category

Syntax

QueryClear(queryObject)
QueryClear(queryObject)
QueryClear(queryObject)

Member function

queryObject.Clear()
queryObject.Clear()
queryObject.Clear()

History

New in ColdFusion (2018 release) Update 5.

Parameters

Parameter

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>
<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>
<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

Get help faster and easier

New user?