title: Uploading data from webscraper to SQL server
body: <p>I am trying to upload web scraped deals to mysql server:</p>
  <pre><code>def sendToSQL(deals, n):
      length = len(deals)
      if length &lt; n:
          print(&quot;Not enough deals&quot;,length,n)
          return
      server = 'zains.database.windows.net'
      database = 'COSC'
      username = 'zainy'
      password = 'pw'
      driver= '{ODBC Driver 17 for SQL Server}'
  
      mydb = pyodbc.connect('DRIVER='+driver+';PORT=1433;SERVER='+server+';PORT=1443;DATABASE='+database+';UID='+username+';PWD='+ password)
      mycursor = mydb.cursor()
      for i in deals[0:n]:
          mycursor.execute(&quot;CREATE TABLE Dealsea(title text, link text, content text, vendor text)&quot;)
          mycursor.execute (&quot;&quot;&quot;
                  INSERT INTO DealSea
                  VALUES
                  (i.getTitle(),i.getLink(),i.getContent(),i.getVendor())&quot;&quot;&quot;)
  
          mydb.commit()
  </code></pre>
  <p>Gives me this error:</p>
  <pre><code>pyodbc.ProgrammingError: ('42000', '[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot find either column &quot;i&quot; or the user-defined function or aggregate &quot;i.getTitle&quot;, or the name is ambiguous. (4121) (SQLExecDirectW)')
  </code></pre>