Python Forum
iterate through query result
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
iterate through query result
#5
No idea about adding tuples to a spreadsheet. The help text for whatever spreadsheet package you are using will provide that information. You mentioned your code worked when you used fetchone(). How does the fetchone() return value differ from the fetchall() return value? Is there a way you can process the fetchall() return value to get what you want?

Why do you think fetchone() and fetchall() return different data types? There has to be a reason. When you understand that reason I think you will no longer have a problem adding values to the spreadsheet.
Reply


Messages In This Thread
iterate through query result - by bigt - Mar-25-2020, 06:16 PM
RE: iterate through query result - by bigt - Mar-25-2020, 07:55 PM
RE: iterate through query result - by deanhystad - Mar-25-2020, 08:03 PM
RE: iterate through query result - by bigt - Mar-25-2020, 08:14 PM
RE: iterate through query result - by deanhystad - Mar-25-2020, 09:28 PM
RE: iterate through query result - by bigt - Mar-25-2020, 11:12 PM
RE: iterate through query result - by bigt - Mar-26-2020, 02:27 PM
RE: iterate through query result - by deanhystad - Mar-26-2020, 03:53 PM
RE: iterate through query result - by buran - Mar-26-2020, 03:57 PM
RE: iterate through query result - by bigt - Mar-26-2020, 04:32 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Write SQLite query result to file hjk6734 1 2,724 May-27-2020, 12:17 PM
Last Post: menator01
  python code (embedded in Redshift) to return result of the query Mel 0 2,936 Aug-24-2018, 06:12 PM
Last Post: Mel

Forum Jump:

User Panel Messages

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