Click here to Skip to main content
14,697,872 members
Home » Discussions » Database
   

Database

 
AnswerRe: Getting error in SQL 2012 working fine in 2016 Pin
jschell27-Dec-18 14:34
Memberjschell27-Dec-18 14:34 
Questionssrs An attempt has been made to use a data extension 'ORACLE' error Pin
anjel8425-Dec-18 21:34
Memberanjel8425-Dec-18 21:34 
AnswerRe: ssrs An attempt has been made to use a data extension 'ORACLE' error Pin
rnbergren24-Jan-19 9:24
Memberrnbergren24-Jan-19 9:24 
QuestionCan't Insert data into Access Table from Python - Solved Pin
Peter R. Fletcher5-Dec-18 16:16
MemberPeter R. Fletcher5-Dec-18 16:16 
AnswerRe: Can't Insert data into Access Table from Python Pin
Richard MacCutchan5-Dec-18 23:19
mveRichard MacCutchan5-Dec-18 23:19 
GeneralRe: Can't Insert data into Access Table from Python Pin
Victor Nijegorodov6-Dec-18 2:09
MemberVictor Nijegorodov6-Dec-18 2:09 
GeneralRe: Can't Insert data into Access Table from Python Pin
Richard MacCutchan6-Dec-18 2:21
mveRichard MacCutchan6-Dec-18 2:21 
GeneralRe: Can't Insert data into Access Table from Python Pin
Peter R. Fletcher6-Dec-18 3:11
MemberPeter R. Fletcher6-Dec-18 3:11 
Richard MacCutchan wrote:
Having looked at the documentation, I guess that the extra parentheses round your values may be the problem. The example is:
cursor.execute("insert into products(id, name) values (?, ?)", 'pyodbc', 'awesome library')

So perhaps your code should be:
cur2.execute('INSERT INTO RawValues (Millitime, PowerCost) VALUES (?,?)', float(row[0]), row[1])



No, the 'extra' parentheses turn the two values to be passed into a single (2-element) Python Tuple, which is what the call wants passed. If this were the problem, Python should be throwing an error. I have written a fair bit of other code, adding data to SQLite tables, which is exactly parallel and works as it should.
GeneralRe: Can't Insert data into Access Table from Python Pin
Richard MacCutchan6-Dec-18 4:16
mveRichard MacCutchan6-Dec-18 4:16 
GeneralRe: Can't Insert data into Access Table from Python Pin
Peter R. Fletcher6-Dec-18 5:37
MemberPeter R. Fletcher6-Dec-18 5:37 
GeneralRe: Can't Insert data into Access Table from Python Pin
Richard MacCutchan6-Dec-18 6:11
mveRichard MacCutchan6-Dec-18 6:11 
GeneralRe: Can't Insert data into Access Table from Python Pin
Richard MacCutchan8-Dec-18 5:46
mveRichard MacCutchan8-Dec-18 5:46 
GeneralRe: Can't Insert data into Access Table from Python Pin
Peter R. Fletcher8-Dec-18 6:04
MemberPeter R. Fletcher8-Dec-18 6:04 
GeneralRe: Can't Insert data into Access Table from Python Pin
Richard MacCutchan8-Dec-18 6:58
mveRichard MacCutchan8-Dec-18 6:58 
GeneralRe: Can't Insert data into Access Table from Python Pin
Peter R. Fletcher8-Dec-18 8:36
MemberPeter R. Fletcher8-Dec-18 8:36 
GeneralRe: Can't Insert data into Access Table from Python Pin
Mycroft Holmes8-Dec-18 12:52
professionalMycroft Holmes8-Dec-18 12:52 
GeneralRe: Can't Insert data into Access Table from Python Pin
Richard MacCutchan8-Dec-18 22:09
mveRichard MacCutchan8-Dec-18 22:09 
QuestionError reading data from SQL Server ? Pin
Member 24584673-Dec-18 23:25
MemberMember 24584673-Dec-18 23:25 
AnswerRe: Error reading data from SQL Server ? Pin
ZurdoDev4-Dec-18 3:22
mveZurdoDev4-Dec-18 3:22 
AnswerRe: Error reading data from SQL Server ? Pin
Eddy Vluggen4-Dec-18 3:55
professionalEddy Vluggen4-Dec-18 3:55 
GeneralRe: Error reading data from SQL Server ? Pin
Member 24584674-Dec-18 18:15
MemberMember 24584674-Dec-18 18:15 
GeneralRe: Error reading data from SQL Server ? Pin
Eddy Vluggen5-Dec-18 2:44
professionalEddy Vluggen5-Dec-18 2:44 
GeneralRe: Error reading data from SQL Server ? Pin
Member 24584679-Dec-18 22:28
MemberMember 24584679-Dec-18 22:28 
GeneralRe: Error reading data from SQL Server ? Pin
Eddy Vluggen10-Dec-18 0:27
professionalEddy Vluggen10-Dec-18 0:27 
SuggestionRe: Error reading data from SQL Server ? Pin
CHill6011-Dec-18 6:18
mveCHill6011-Dec-18 6:18 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.