您没有为绑定3提供值

Question

我只是想在我的数据库中插入一些值，但是我得到了某种绑定错误。你知道吗

  c.execute("INSERT INTO research_details VALUES (:s_no,:name_of_project,:name_of_principal,:name_of_funding_ag,:type ,:dept_of_co_inv ,:year ,:funds_provided,:duration ,:link1 ,:link2)",


               {
                's_no': s_no.get(),
                'name_of_project': name_of_pro.get(),
                'name_principal':co_invst.get(),
                'name_agency':name_of_fagency.get(),
                'type':typ.get(),
                'dept':dep.get(),
                'year':yr.get(),
                'funds_provided':fun.get(),
                'duration':dtn.get(),
                'link1':ln1.get(),
                'link2':ln2.get() #THIS LINE IS GIVING ERROR !
               })

显示错误

You did not supply a value for binding 3.

Answer 1

c.execute("INSERT INTO research_details VALUES (:s_no,:name_of_project,:name_of_principal,:name_of_funding_ag,:type ,:dept_of_co_inv ,:year ,:funds_provided,:duration ,:link1 ,:link2)",

          dict(s_no=s_no.get(), name_of_project=name_of_pro.get(), name_of_principal=co_invst.get(),
               name_of_funding_ag=name_of_fagency.get(), type=typ.get(), dept_of_co_inv=dep.get(), year=yr.get(),
               funds_provided=fun.get(), duration=dtn.get(), link1=ln1.get(), link2=ln2.get()))