Whatever message this page gives is out now! Go check it out!
QueryDeleteRow
Last update:
May 18, 2026
Description
Deletes a row from a query object.
Returns
Returns the modified query object.
Category
Syntax
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
<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
<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>
We're glad. Tell us how this page helped.
We're sorry. Can you tell us what didn't work for you?
Share additional feedback to help us improve.
0/255
|
