Python Forum
results for sql server query not as expected
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
results for sql server query not as expected
#3
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.
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
Reply


Messages In This Thread
RE: results for sql server query not as expected - by kat35601 - Sep-13-2018, 03:25 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Method works as expected on host machine but not on server gradlon93 4 1,201 Jan-05-2023, 10:41 AM
Last Post: DeaD_EyE
  Mysql error message: Lost connection to MySQL server during query tomtom 6 16,755 Feb-09-2022, 09:55 AM
Last Post: ibreeden
  TypeError: sequence item 0: expected str instance, float found Error Query eddywinch82 1 5,338 Sep-04-2021, 09:16 PM
Last Post: eddywinch82
  How to take the tar backup files form remote server to local server sivareddy 0 2,007 Jul-14-2021, 01:32 PM
Last Post: sivareddy
  Search Results Web results Printing the number of days in a given month and year afefDXCTN 1 2,330 Aug-21-2020, 12:20 PM
Last Post: DeaD_EyE
  How to append one function1 results to function2 results SriRajesh 5 3,320 Jan-02-2020, 12:11 PM
Last Post: Killertjuh
  Error Handling/No results from SQL Query JP_ROMANO 7 9,901 Jul-18-2018, 02:31 PM
Last Post: JP_ROMANO
  Greenplum Query results to Email HTML table krux_rap 1 2,579 Apr-10-2018, 09:12 PM
Last Post: Larz60+
  Extract SQL Query Results in Python boobalganesan 3 12,033 Jan-11-2018, 07:31 PM
Last Post: buran

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020