json just showing 1 row

    qdata = {} of String => String
    db.query "select column1, column2, column3 from table" do |rs|
      rs.each do
        qdata["title"] = rs.read(String)
        qdata["desc"] = rs.read(String)
        lats = rs.read(String).split('~')
        qdata["lat"] = lats[0]
        qdata["long"] = lats[1]
      end
    end
    puts qdata.to_json