QueryClear

QueryClear

Išči

某些 Creative Cloud 应用程序、服务和功能在中国不可用。

Description

Deletes all records in a query object.

Returns

An empty query object with all records deleted.

Category

Query functions

Syntax

1
QueryClear(queryObject)

Member function

1
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

QueryDeleteRow

Example

1
2
3
4
5
6
7
8
9
<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

original_query_objectnew

After applying QueryClear

after_applying_queryclearnew