Sep-13-2018, 03:25 PM
This is my first query using python.
how would I drop the "u" and "decimal" from the printed results?
also is correct way to print the results? It does seem to put me in an endless loop.
how would I drop the "u" and "decimal" from the printed results?
also is correct way to print the results? It does seem to put me in an endless loop.
for row in cursor.execute('select top 1 ompSalesOrderID, ompfullorderSubtotalBase from server.dbo.SalesOrders left join server.dbo.SalesOrderLines on omlSalesOrderID=ompSalesOrderID '): while row: print ((row[0] , row[1]) )Thanks for the Guidance