comparing an int variable to MSSQL query results Python via pymssql

Question

I'm trying to compare a variable to query results in the following which are dates in yyyymmdd format. The database field LastUpdate is of type int.

When I test this, I think I am getting the false result because the query is a tuple compared to my variable as int.

Is there a way to convert the (20160422,) to an int?

import pymssql

conn = pymssql.connect(server='', user='', password='', database='')

cur = conn.cursor()
cur.execute('SELECT Top 1 LastUpdate FROM tbl_Date')

myDate = 20160422

for row in cur:
    print(row)

    if row == myDate:
        print('true')
        #then do something
    else:
        print('false')

conn.close()

Have you tried simply taking the first item in the `row` tuple: `row[0]` ...? — Gord Thompson, Apr 25 '16 at 14:25

score 1 · Accepted Answer · answered Apr 26 '16 at 09:02

As your suggestion, I've got this working based as follows; I just wasn't sure how to access elements of an array in Python, I just needed a clue. Thanks again.

import pymssql

conn = pymssql.connect(server='', user='', password='', database='')

cur = conn.cursor()
cur.execute('SELECT Top 1 LastUpdate FROM tbl_Date')

myDate = 20160426

for row in cur:
    print(row[0])

if row[0] == myDate:
    print('true')
    #then do something
else:
    print('false')

conn.close()

comparing an int variable to MSSQL query results Python via pymssql

1 Answers1