Click here to Skip to main content
13,836,661 members
   

Database

 
PinnedHOW TO ANSWER A QUESTION PinPopular
Chris Maunder16-Jul-09 4:10
adminChris Maunder16-Jul-09 4:10 
PinnedHow to get an answer to your question PinPopular
Chris Maunder10-Nov-05 17:30
adminChris Maunder10-Nov-05 17:30 
Questionis it safe to use this with sql server and entity framework ? Pin
desanti9-Jan-19 15:38
memberdesanti9-Jan-19 15:38 
AnswerRe: is it safe to use this with sql server and entity framework ? Pin
Mycroft Holmes9-Jan-19 20:51
memberMycroft Holmes9-Jan-19 20:51 
AnswerRe: is it safe to use this with sql server and entity framework ? Pin
Eddy Vluggen10-Jan-19 3:17
mveEddy Vluggen10-Jan-19 3:17 
AnswerMessage Closed Pin
17-Jan-19 19:25
memberMember 1412184017-Jan-19 19:25 
QuestionGetting error in SQL 2012 working fine in 2016 Pin
GaneshVidiyala25-Dec-18 22:41
professionalGaneshVidiyala25-Dec-18 22:41 
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 
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
protectorRichard 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
protectorRichard 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
protectorRichard 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
protectorRichard MacCutchan6-Dec-18 6:11 
GeneralRe: Can't Insert data into Access Table from Python Pin
Richard MacCutchan8-Dec-18 5:46
protectorRichard 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
protectorRichard 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
memberMycroft Holmes8-Dec-18 12:52 
GeneralRe: Can't Insert data into Access Table from Python Pin
Richard MacCutchan8-Dec-18 22:09
protectorRichard 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
professionalZurdoDev4-Dec-18 3:22 

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.


Advertise | Privacy | Cookies | Terms of Service
Web06 | 2.8.190114.1 | Last Updated 18 Jan 2019
Copyright © CodeProject, 1999-2019
All Rights Reserved.
Layout: fixed | fluid