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
#1
what am I doing wrong and what is with all the letters u??
for row in cursor.execute('select top 1 *  from  server.dbo.SalesOrders left join  server.dbo.SalesOrderLines on omlSalesOrderID=ompSalesOrderID '):
   print(row)
results:

(u'10000', u'', u'', u'10009', u'', u'', u'', u'', u'10009', u'1', u'', u'8192011', datetime.datetime(2011, 8, 19, 0, 0), datetime.datetime(2011, 8, 19, 0, 0), u'SHIPPING POINT', u'KITH', u'', u'2TN30', u'', u'', u'', None, None, False, False, u'', u'', False, Decimal('1.000000'), Decimal('2991.80'), Decimal('2991.80'), Decimal('0.00'), Decimal('0.00'), Decimal('2991.80'), Decimal('2991.80'), Decimal('0.00'), Decimal('0.00'), Decimal('0.00000'), Decimal('299.18'), Decimal('299.18'), Decimal('299.18'), Decimal('299.18'), u'', Decimal('0.00'), Decimal('0.00'), u'', Decimal('0.00'), Decimal('0.00'), Decimal('0.00'), Decimal('0.00'), Decimal('3290.98'), Decimal('3290.98'), 3, None, None, u'', u'', True, datetime.datetime(2011, 9, 6, 0, 0), False, Decimal('0.00'), False, Decimal('0.00'), Decimal('0.00'), u'', False, u'KIM', datetime.datetime(2011, 8, 19, 10, 23, 52), '04EBA251-1493-486C-B1E0-A4FCDABCE86C', u'', u'', False, False, u'', u'', u'', u'', u'', u'', u'', 0, None, None, False, Decimal('0.00'), Decimal('299.18'), False, None, u'', u'', u'', u'NON', u'', False, Decimal('0.00'), False, Decimal('0.00'), u'', 5, Decimal('0.00'), u'', u'', False, False, None, Decimal('0.00'), None, Decimal('0.00'), Decimal('0.00'), u'0', u'', u'', False, u'', Decimal('0.00'), datetime.datetime(2011, 9, 2, 0, 0), False, Decimal('0.00'), u'', False, Decimal('0.00'), False, 0, False, False, False, u'', False, u'10000', u'', False, False, False, u'', u'', 0, False, u'', False, False, u'', Decimal('0.00'), Decimal('0.00'), Decimal('43'), Decimal('0.00'), Decimal('0.00'), Decimal('0.00'), Decimal('0.00'), u'F0006', Decimal('423.74'), Decimal('0.00000'), Decimal('0.00'), Decimal('0.00'), Decimal('100.00'), u'', False, u'10000', 1, u'110-39', u'', u'', u'EA', u'110', u'Twin Bookcase HB -Tanner -Brazilian Cherry', u'', None, None, Decimal('2.00000'), Decimal('52.00000'), Decimal('52.00000'), Decimal('0.00'), Decimal('0.00000'), Decimal('0.00000'), Decimal('52.00000'), Decimal('52.00000'), Decimal('104.00'), Decimal('104.00'), Decimal('0.00'), Decimal('0.00'), Decimal('104.00'), Decimal('104.00'), Decimal('0.00'), Decimal('0.00'), u'', u'RESAL', Decimal('0.00'), Decimal('0.00'), u'', Decimal('0.00'), Decimal('0.00'), True, False, Decimal('2.00000'), u'', 0, 0, u'', 0, u'', 0, False, u'', u'', Decimal('0.00000'), u'', u'', 0, True, False, False, Decimal('0.00'), Decimal('0.00'), Decimal('0.00'), False, False, None, False, u'KIM', datetime.datetime(2011, 8, 19, 10, 28, 21), '415BC3CD-BB7A-47DB-987A-C7E8CF2815E0', Decimal('0.00'), u'', Decimal('5.36'), Decimal('2'), u'', Decimal('0.000'), u'', u'', False, u'', False, False, False, Decimal('0.00'), u'', u'', u'', u'', Decimal('0.00'), Decimal('0.00'), Decimal('0.00'), Decimal('0.00'), Decimal('0.00'), Decimal('0.00'), u'', u'', Decimal('0.00'), Decimal('0.00000'), Decimal('10.72'), Decimal('0.00000'), Decimal('2.00000'), u'', u'')
Reply


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

Possibly Related Threads…
Thread Author Replies Views Last Post
  Method works as expected on host machine but not on server gradlon93 4 1,187 Jan-05-2023, 10:41 AM
Last Post: DeaD_EyE
  Mysql error message: Lost connection to MySQL server during query tomtom 6 16,614 Feb-09-2022, 09:55 AM
Last Post: ibreeden
  TypeError: sequence item 0: expected str instance, float found Error Query eddywinch82 1 5,294 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,988 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,315 Aug-21-2020, 12:20 PM
Last Post: DeaD_EyE
  How to append one function1 results to function2 results SriRajesh 5 3,302 Jan-02-2020, 12:11 PM
Last Post: Killertjuh
  Error Handling/No results from SQL Query JP_ROMANO 7 9,798 Jul-18-2018, 02:31 PM
Last Post: JP_ROMANO
  Greenplum Query results to Email HTML table krux_rap 1 2,567 Apr-10-2018, 09:12 PM
Last Post: Larz60+
  Extract SQL Query Results in Python boobalganesan 3 11,984 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