Click here to Skip to main content
14,689,511 members
Home » Discussions » Database
   

Database

 
AnswerRe: is it safe to use this with sql server and entity framework ? Pin
Eddy Vluggen10-Jan-19 3:17
professionalEddy Vluggen10-Jan-19 3:17 
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 
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 
Richard MacCutchan wrote:
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.

Hmmm...
It seems to me there are two values here:
Quote:
cur2.execute('INSERT INTO RawValues (Millitime, PowerCost) VALUES (?,?)',(float(row[0]),row[1]))

The first is
Quote:
float(row[0])
, the second -
Quote:
row[1]

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 
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 

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.