Python 中参数查询的语法 (pyodbc)
我正在尝试将某些处理的结果写入 SQL Server 表中.我的结果存储在列表列表中,其中列表的每个项目都是一个列表.我正在使用参数(6 个参数),但出现以下错误:
I am trying to write results of some processing into SQL Server table. My results are store in a list of lists where each item of the list is a list. I am using parameters (6 params) and I am getting the following error:
cnxn.execute(sqlStatement, (item[0],item[1],item[2],item[3],item[4],item[5]))pyodbc.ProgrammingError: ('SQL 包含 0 个参数标记,但提供了 6 个参数', 'HY000')
cnxn.execute(sqlStatement, (item[0],item[1],item[2],item[3],item[4],item[5])) pyodbc.ProgrammingError: ('The SQL contains 0 parameter markers, but 6 parameters were supplied', 'HY000')
这是我的代码
sqlStatement = "INSERT INTO CEA_CR (`SessionID`, `Session.Call_TYPE_Assigned`, `Session.Did_Call_Type_happen_on_this_call`, `Session.Was_there_a_system_or_Rep_generated_Memo_that_matches_with_Call_Type` , 'cycle' , 'version') VALUES (%s, %s, %s, %s ,%s ,%s)"
for item in result:
wr.writerow(item)
cnxn.execute(sqlStatement, (item[0],item[1],item[2],item[3],item[4],item[5]))
cnxn.commit()
有人知道为什么我的执行失败了吗?
Anyone knows why my execution fails ?
推荐答案
您应该使用 ?作为我相信的参数标记.
You should be using ? as parameter markers I believe.
你的 sql 应该是这样的:
Your sql should probably look like this:
sqlStatement = "INSERT INTO CEA_CR (SessionID, Session.Call_TYPE_Assigned, Session.Did_Call_Type_happen_on_this_call, Session.Was_there_a_system_or_Rep_generated_Memo_that_matches_with_Call_Type, cycle, version) VALUES (?, ?, ?, ?, ?, ?)"
相关文章