PYODBC Print Cursor Output Question

[MRAB]

On 10/09/2012 15:55, james simpson wrote:
> I think there's a simple answer but displaying my ignorance here.
> I'm
> using Python 2.7.3 IDLW with pydoc 3x
>
> I think I've connected to my SQL Server 2005 and my SQL is good.
>
> How do I display the actual data returned from my fetch?  Been
> searching for several hours but no joy...
>
> Thanks. Jamie
>
> ===============================================
>>>> cursor.execute("select * from project")
>
> row = cursor.fetchone()
> if row:
>      print row
>
> <pyodbc.Cursor object at 0x0167D678>   I'd like to actually see SQL
> output here?)
>
>
Try this:

 >>> results = cursor.execute("select * from project")
 >>> row = results.fetchone()
 >>> print row