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,150 Jan-05-2023, 10:41 AM
Last Post: DeaD_EyE
  Mysql error message: Lost connection to MySQL server during query tomtom 6 16,460 Feb-09-2022, 09:55 AM
Last Post: ibreeden
  TypeError: sequence item 0: expected str instance, float found Error Query eddywinch82 1 5,233 Sep-04-2021, 09:16 PM
Last Post: eddywinch82
  How to take the tar backup files form remote server to local server sivareddy 0 1,957 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,292 Aug-21-2020, 12:20 PM
Last Post: DeaD_EyE
  How to append one function1 results to function2 results SriRajesh 5 3,245 Jan-02-2020, 12:11 PM
Last Post: Killertjuh
  Error Handling/No results from SQL Query JP_ROMANO 7 9,696 Jul-18-2018, 02:31 PM
Last Post: JP_ROMANO
  Greenplum Query results to Email HTML table krux_rap 1 2,548 Apr-10-2018, 09:12 PM
Last Post: Larz60+
  Extract SQL Query Results in Python boobalganesan 3 11,922 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