sql errors

#This works :
      try:
                            curs.execute("INSERT INTO  nvd_cpe(cpe) VALUES (\"" + nvd_cpe + "\");")
                        except Exception as e:
                            print e
                            
                            
#This does not work ( using single quotes): error Unknown column nvd_cpe in "field list" 

    try:
                            curs.execute('INSERT INTO  nvd_cpe(cpe) VALUES (\"" + nvd_cpe + "\");')
                        except Exception as e:
                            print e
#This does not work : (None, '1 parameters expected, 35 given', None)
 #                     (None, '1 parameters expected, 30 given', None)
  #                    (None, '1 parameters expected, 34 given', None)
    #                   (None, '1 parameters expected, 31 given', None)             
                       
                       try:
                            curs.execute('INSERT INTO  nvd_cpe(cpe) VALUES (?)', nvd_cpe)
                        except Exception as e:
                            print e

try :
curs.execute('INSERT INTO nvd_cpe
(cpe, cpe_part, cpe_vendor, cpe_product, cpe_version, cpe_update,
cpe_edition, cpe_language) VALUES (?, ?, ?, ?, ?, ?, ?, ?)',
(nvd_cpe, nvd_cpe_variables[2], nvd_cpe_variables[3], nvd_cpe_variables[4],
nvd_cpe_variables[5], nvd_cpe_variables[6], nvd_cpe_variables[7],
nvd_cpe_variables[8])
except Exception as e:
print e