SQL challenge yet again

[Erwin van der Zwart]

Hi,

Here is a simplified version (:

Code:

function deleteGA(start, stop)
  startID = knxlib.encodega(start)
  stopID = knxlib.encodega(stop)
  if stopID < startID then
    log('Start has higher value than stop. Delete is not possible')
  else
    result = db:query('DELETE FROM objects WHERE ID BETWEEN ? AND ?', startID, stopID)
    log(result .. ' address(es) within range is/are deleted')
  end
end

deleteGA('26/0/0', '26/0/10')
deleteGA('26/0/51', '26/0/70')

BR,

Erwin