Function Sequence Error (0) (sqlfetch) - Sql, Pyodbc

for _item in file_list: for col in cursor.execute('select column1,column2 from tbl'): if _item[0]==col.column1: #I also tried using a different cursor, stil

Solution 1:

What you're doing is fine and should work per @ScottMorken's comment to this answer.

---

Old answer: You need to retrieve the results of the query using, for example, .fetchall() So instead of that line you could do:

for columnrow in cursor.execute("select column1,column2 from tbl").fetchall():
    ...