queryDeleteRow

Deletes a row within a query object.

queryDeleteRow(query [, row]) → returns boolean

Member Function Syntax

query.deleteRow([row])

Argument Reference

query query
Required

Query to modify

row numeric
Default: `-9999`

Index of the row to delete, starts at 1. If a row is not specified, the last row is removed.

Examples
Sample code invoking the queryDeleteRow function

Implicit deletion of the last row

Builds a simple query and removes the last row by not specifying a row index.

news = queryNew("id,title", "integer,varchar", [ {"id":1,"title":"Dewey defeats Truman"}, {"id":2,"title":"Man walks on Moon"} ]);
queryDeleteRow(news);
writeOutput(news['title'][1]);

Expected Result: Dewey defeats Truman

Deletes a specific row from the query

Builds a simple query and removes one of the rows.

news = queryNew("id,title", "integer,varchar", [ {"id":1,"title":"Dewey defeats Truman"}, {"id":2,"title":"Man walks on Moon"} ]);
queryDeleteRow(news, 1);
writeOutput(news['title'][1]);

Expected Result: Man walks on Moon

Signup for cfbreak to stay updated on the latest news from the ColdFusion / CFML community. One email, every friday.

Fork me on GitHub