QueryDeleteRow

ColdFusion

Öppna appen

Description

Deletes a row from a query object.

Returns

Returns the modified query object.

Syntax

QueryDeleteRow(Object queryObject, int rowNum)

QueryDeleteRow(Object queryObject, int rowNum)

History

New in ColdFusion (2018 release).

Parameters

Parameter	Required/Optional	Description
queryObject	Required	The query object in which a column is to be deleted.
rowNum	Required	The row number corresponding to the row to be deleted.

Example 1

myQuery = queryNew("id,name,amount","Integer,Varchar,Integer",

[

{id=1,name="One",amount=15},

{id=2,name="Two",amount=18},

{id=3,name="Three",amount=32}

]);

writeOutput("The original query object is:")

writeDump(myQuery)

// Delete row

QueryDeleteRow(myQuery,1)

writeOutput("The modified query object is:")

writeDump(myQuery)

</cfscript>

<cfscript> myQuery = queryNew("id,name,amount","Integer,Varchar,Integer", [ {id=1,name="One",amount=15}, {id=2,name="Two",amount=18}, {id=3,name="Three",amount=32} ]); writeOutput("The original query object is:") writeDump(myQuery) // Delete row QueryDeleteRow(myQuery,1) writeOutput("The modified query object is:") writeDump(myQuery) </cfscript>

<cfscript>
    myQuery = queryNew("id,name,amount","Integer,Varchar,Integer", 
                [ 
                        {id=1,name="One",amount=15}, 
                        {id=2,name="Two",amount=18}, 
                        {id=3,name="Three",amount=32} 
                ]); 
    writeOutput("The original query object is:")
    writeDump(myQuery)
    // Delete row
    QueryDeleteRow(myQuery,1)
    writeOutput("The modified query object is:")
    writeDump(myQuery)
</cfscript>

Output

Example 2

myResult=QueryExecute(("SELECT * FROM EMPLOYEES WHERE EMP_ID BETWEEN :low AND :high"),{low=4,high=14},

{datasource="cfdocexamples"});

writeOutput("Array before deleting any row" & " ");

writeDump(myResult);

writeOutput("Deleting row 2" & " ");

myDeletedRow=QueryDeleteRow(myResult,2);

// Display output after row deletion

writeOutput(" " & myDeletedRow);

writeOutput(" " & "Array after deleting the row" & " ");

WriteDump(myResult);

</cfscript>

<cfscript> myResult=QueryExecute(("SELECT * FROM EMPLOYEES WHERE EMP_ID BETWEEN :low AND :high"),{low=4,high=14}, {datasource="cfdocexamples"}); writeOutput("Array before deleting any row" & " "); writeDump(myResult); writeOutput("Deleting row 2" & " "); myDeletedRow=QueryDeleteRow(myResult,2); // Display output after row deletion writeOutput(" " & myDeletedRow); writeOutput(" " & "Array after deleting the row" & " "); WriteDump(myResult); </cfscript>

<cfscript>
  myResult=QueryExecute(("SELECT * FROM EMPLOYEES WHERE EMP_ID BETWEEN :low AND :high"),{low=4,high=14},
       {datasource="cfdocexamples"});
     writeOutput("Array before deleting any row" & "<br/>");
     writeDump(myResult);
     writeOutput("Deleting row 2" & "<br/>");
     myDeletedRow=QueryDeleteRow(myResult,2);
     // Display output after row deletion
     writeOutput("<br/>" & myDeletedRow);
     writeOutput("<br/>" & "Array after deleting the row" & "<br/>");
     WriteDump(myResult);
</cfscript>

Få hjälp snabbare och enklare

Ny användare?