Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
python sql help
#1
hello, i am a rather beginner for programming, certainly to python.
i wrote a piece of code in python, helped myself by the numerous tutorials online

the piece of code is getting data from my sql server
it gets the data in via a cursor

within the cursor i am testing the data on several points
for 1 of the points i need to retrieve data from another table in the database

but when i am calling the database again from within the cursor i get following failure code:
Error:
connection-is-busy-with-results-for-another-hstmt
i am sure this is a common problem but cannot find help online
what is a common routine to solve this problem?

things i've been thinking about:
-store the retrieved lines temporarely in another table ==> same problem
-store the retrieved lines in a CSV ==> looks not so neat in my opinion
-...

thanks for your help, directing me to a tutorial where everything is explained would be the most perfect outcome for this question
Reply


Messages In This Thread
python sql help - by keuninkske - Nov-17-2019, 07:48 PM
RE: python sql help - by Larz60+ - Nov-17-2019, 11:23 PM
RE: python sql help - by keuninkske - Nov-18-2019, 07:50 PM
RE: python sql help - by ndc85430 - Apr-05-2020, 02:21 PM
RE: python sql help - by SnoopFrogg - Nov-19-2019, 02:50 PM
RE: python sql help - by keuninkske - Nov-20-2019, 07:38 PM
RE: python sql help - by SnoopFrogg - Nov-20-2019, 10:36 PM
RE: python sql help - by keuninkske - Apr-05-2020, 01:39 PM
RE: python sql help - by keuninkske - Apr-05-2020, 05:52 PM

Forum Jump:

User Panel Messages

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