Lucee Function Reference

queryrowswap()

swaps one row of a query with an other.

Example

queryrowswap(query query,numeric source,numeric destination):query

Category

query

Arguments

The arguments for this function are set. You can not use other arguments except the following ones.
Name Type Required Description
query query  Yes query to swap rows.  
source numeric  Yes The row to swap.  
destination numeric  Yes The row to be swapped with.