Click here to Skip to main content
15,900,816 members
Home / Discussions / Database
   

Database

 
GeneralRe: Having difficulty to replicate entries in SQL query result Pin
Mycroft Holmes29-Jan-19 10:58
professionalMycroft Holmes29-Jan-19 10:58 
GeneralRe: Having difficulty to replicate entries in SQL query result Pin
paul4everyone31-Jan-19 10:50
paul4everyone31-Jan-19 10:50 
GeneralRe: Having difficulty to replicate entries in SQL query result Pin
Mycroft Holmes31-Jan-19 11:15
professionalMycroft Holmes31-Jan-19 11:15 
GeneralRe: Having difficulty to replicate entries in SQL query result Pin
paul4everyone2-Feb-19 19:03
paul4everyone2-Feb-19 19:03 
GeneralRe: Having difficulty to replicate entries in SQL query result Pin
Mycroft Holmes2-Feb-19 19:29
professionalMycroft Holmes2-Feb-19 19:29 
Questionis it safe to use this with sql server and entity framework ? Pin
desanti9-Jan-19 14:38
desanti9-Jan-19 14:38 
AnswerRe: is it safe to use this with sql server and entity framework ? Pin
Mycroft Holmes9-Jan-19 19:51
professionalMycroft Holmes9-Jan-19 19:51 
AnswerRe: is it safe to use this with sql server and entity framework ? Pin
Eddy Vluggen10-Jan-19 2:17
professionalEddy Vluggen10-Jan-19 2:17 
QuestionGetting error in SQL 2012 working fine in 2016 Pin
GaneshVidiyala25-Dec-18 21:41
professionalGaneshVidiyala25-Dec-18 21:41 
AnswerRe: Getting error in SQL 2012 working fine in 2016 Pin
jschell27-Dec-18 13:34
jschell27-Dec-18 13:34 
Questionssrs An attempt has been made to use a data extension 'ORACLE' error Pin
anjel8425-Dec-18 20:34
anjel8425-Dec-18 20:34 
AnswerRe: ssrs An attempt has been made to use a data extension 'ORACLE' error Pin
rnbergren24-Jan-19 8:24
rnbergren24-Jan-19 8:24 
QuestionCan't Insert data into Access Table from Python - Solved Pin
Peter R. Fletcher5-Dec-18 15:16
Peter R. Fletcher5-Dec-18 15:16 
AnswerRe: Can't Insert data into Access Table from Python Pin
Richard MacCutchan5-Dec-18 22:19
mveRichard MacCutchan5-Dec-18 22:19 
The float built-in only takes a single parameter, you are passing two, so that code will fail. Also you have specified two values in your insert statement but you are trying to pass only one.Victor pointed out my mistake.

[edit]
Having looked at the documentation, I guess that the extra parentheses round your values may be the problem. The example is:
Python
cursor.execute("insert into products(id, name) values (?, ?)", 'pyodbc', 'awesome library')

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


[/edit]

modified 6-Dec-18 7:54am.

GeneralRe: Can't Insert data into Access Table from Python Pin
Victor Nijegorodov6-Dec-18 1:09
Victor Nijegorodov6-Dec-18 1:09 
GeneralRe: Can't Insert data into Access Table from Python Pin
Richard MacCutchan6-Dec-18 1:21
mveRichard MacCutchan6-Dec-18 1:21 
GeneralRe: Can't Insert data into Access Table from Python Pin
Peter R. Fletcher6-Dec-18 2:11
Peter R. Fletcher6-Dec-18 2:11 
GeneralRe: Can't Insert data into Access Table from Python Pin
Richard MacCutchan6-Dec-18 3:16
mveRichard MacCutchan6-Dec-18 3:16 
GeneralRe: Can't Insert data into Access Table from Python Pin
Peter R. Fletcher6-Dec-18 4:37
Peter R. Fletcher6-Dec-18 4:37 
GeneralRe: Can't Insert data into Access Table from Python Pin
Richard MacCutchan6-Dec-18 5:11
mveRichard MacCutchan6-Dec-18 5:11 
GeneralRe: Can't Insert data into Access Table from Python Pin
Richard MacCutchan8-Dec-18 4:46
mveRichard MacCutchan8-Dec-18 4:46 
GeneralRe: Can't Insert data into Access Table from Python Pin
Peter R. Fletcher8-Dec-18 5:04
Peter R. Fletcher8-Dec-18 5:04 
GeneralRe: Can't Insert data into Access Table from Python Pin
Richard MacCutchan8-Dec-18 5:58
mveRichard MacCutchan8-Dec-18 5:58 
GeneralRe: Can't Insert data into Access Table from Python Pin
Peter R. Fletcher8-Dec-18 7:36
Peter R. Fletcher8-Dec-18 7:36 
GeneralRe: Can't Insert data into Access Table from Python Pin
Mycroft Holmes8-Dec-18 11:52
professionalMycroft Holmes8-Dec-18 11:52 

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.