sql = "select id from agent where extension = '9072' limit 1"
cursor,errorString = conn:execute(sql)
value = nil
if cursor then
  row = cursor:fetch ({}, "a")    -- we'll have 0 or 1 rows
  if row then value = row.id end
end