title: Converting values from sqlite results
body: <p><a href="https://i.stack.imgur.com/oeYtc.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/oeYtc.png" alt="Issue Image and expected output "></a></p>
  
  <p>I am having trouble in converting from list to separate strings in python. Below is the code used to get the strings and the exception: </p>
  
  <p>Code:</p>
  
  <pre><code>mycursor.execute("SELECT fid,contents,input_type  FROM frame_report1")
  
  myresult = mycursor.fetchall()
  print myresult
  # myresult ---&gt;[(449, u'text1', u'checkbox'), (454, u'text2', u'textbox'), (455, u'text3', u'textbox')]
  print type(myresult)#list type
  for x,x1,x2 in myresult:
      g = int(''.join(map(str, x))) #int type
      l = ''.join( x1) #string type
      k = ''.join( x2) #string type
  </code></pre>
  
  <p>Exception:</p>
  
  <pre><code>g = ''.join(map(str, x))
  TypeError: argument 2 to map() must support iteration
  </code></pre>
  
  <p>I want to convert values from <code>myresult</code> to the variables <code>g</code>, <code>l</code>, and <code>k</code>.</p>
  
  <p>EDIT :
  @Matt B : thanks for the response, I have used the code mentioned by you but its not helpfull, we need to get the row content 449, 454 455 in separate String array, currently i am getting combined. please guide, thanks in adavance, please check the image attached Image showing issue image and expected image. </p>
  
  <p>Code :</p>
  
  <pre><code>myresult = [(449, u'text1', u'checkbox'), (454, u'text2', u'textbox'), (455, u'text3', u'textbox')]
  row = 0
  for x, x1, x2 in myresult:
      g = int(''.join(map(str, x)))  # int type
  
      l = ''.join(x1)  # string type
      k = ''.join(x2)  # string type
      rcount_general = self.tableWidget.rowCount()
      self.tableWidget.insertRow(rcount_general)
      r = 0
      for i in range(rcount_general + 1):
          self.tableWidget.setItem(row, 0, QtGui.QTableWidgetItem(g))
          self.tableWidget.setItem(row, 1, QtGui.QTableWidgetItem(l))
          self.tableWidget.setItem(row, 2, QtGui.QTableWidgetItem(k))        
          r = r + 1
      row = row + 1
  </code></pre>