Python Forum
Python Forum

Search Results
Post Author Forum Replies Views Posted [asc]
    Thread: Problem with pyodbc executemany()
Post: Problem with pyodbc executemany()
Well, here goes again, I am trying in vain to insert multiple rows to SQLServer using pyodbc executemany. the data is in a dict. When I do this I get #pyodbc.ProgrammingError: The second parameter to ...
 RBeck22 General Coding Help 1 7,425 Apr-01-2019, 06:02 PM
    Thread: PyODBC error - second parameter to executemany must be a sequence, iterator, or gener
Post: RE: PyODBC error - second parameter to executemany...
Hello Larx60+ Here is the code, Let me know if what else is needed> Thanks import requests from requests.auth import HTTPDigestAuth import json from pandas.io.json import json_normalize import pand...
 RBeck22 General Coding Help 1 7,099 Mar-29-2019, 06:44 PM
    Thread: PyODBC error - second parameter to executemany must be a sequence, iterator, or gener
Post: PyODBC error - second parameter to executemany mus...
Hello, I am trying this to get some values into SQLServer2017. when I try this code it throws pyodbc.ProgrammingError: The second parameter to executemany must be a sequence, iterator, or generator. ...
 RBeck22 General Coding Help 1 7,099 Mar-29-2019, 05:09 PM
    Thread: Trouble converting JSON String to Dictionary
Post: RE: Trouble converting JSON String to Dictionary
Hello All, and Thanks!!! I got it partially solved: for i in x: x['key'][0]['other']) x['key'][1]['blahblah']) Anyway thanks for the help!
 RBeck22 General Coding Help 7 5,139 Mar-28-2019, 12:12 PM
    Thread: Trouble converting JSON String to Dictionary
Post: RE: Trouble converting JSON String to Dictionary
Hello and thanks hereis the JSON i am getting dict_values([[{'Id': '0f94fcef-0018-47a8-a0e7-7940012d6c27', 'originid': 1130793332, 'userid': 'u28635272', 'targetid': 1222129914
 RBeck22 General Coding Help 7 5,139 Mar-26-2019, 09:25 PM
    Thread: Trouble converting JSON String to Dictionary
Post: RE: Trouble converting JSON String to Dictionary
Larrz60+ Thanks, tried it, thows: "TypeError: the JSON object must be str, bytes or bytearray, not dict"
 RBeck22 General Coding Help 7 5,139 Mar-26-2019, 05:26 PM
    Thread: Trouble converting JSON String to Dictionary
Post: Trouble converting JSON String to Dictionary
Hello All: I am fairly new to python, so I have a small app that pulls data from REST using requests this returns a response object that I convert to JSON with this jData = restResponse.json() #Conv...
 RBeck22 General Coding Help 7 5,139 Mar-26-2019, 12:36 PM

User Panel Messages

Log Out
My Profile
Pay your profile a visit
User Control Panel
Do some changes on your profile
My Messages
View private messages unread
Avatar
Change avatar
Signature
Change signature
Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020