[Lt Llama]

Just fixed an issue in a plugin where the task is to pick the last line in a result set from a database query. Im not shure which is the best way to pick the last row. It feels like overkill to make a while loop to run through all rows, just to get to the last one.

Any better way to do this than:

while (incrementRows < numberOfRowsInResultSet) {
   dbi_nextrow(resultSet)
   ++incrementRows
}

Thx

/Lt.

[Hawk552]

Use SQLx.

[Lt Llama]

There is no method on SQLx to pick the last row in a result set, or have I missed something?

[Hawk552]

Originally Posted by Lt Llama There is no method on SQLx to pick the last row in a result set, or have I missed something?

No, but it's still better for this purpose.