Does pyodbc have an execute scalar function

Question

Does pyodbc have an execute scalar function?

something like executescalar on the sql lib in .net?

Answer 1

The pyodbc cursor has a fetchone() method.

cursor.execute("select user_name from users where user_id=?", userid)
row = cursor.fetchone()
if row:
    print row.user_name 
    # or print row[0]