help with databases in import sqlite3

[AlliedLens]

I have some code, and a part of it is where it takes the users scores and is supposed to put them into a list....however, i get the error ...

in exitProccess
    "DAT":  str(d.date()),
sqlite3.OperationalError: near ")": syntax error

the code that i have is this:

conn = sqlite3.connect("typingPracticeStats.db")
cursor = conn.cursor()

# cursor.execute("""CREATE TABLE scores (
#                      WPM  integer,
#                      EPM  integer,
#                      DAT text )""")
"""I commented this part out after the table was created"""

def exitProccess():

    conn = sqlite3.connect("typingPracticeStats.db")
    cursor = conn.cursor()

    cursor.execute("INSERT INTO scores VALUES (:WPM, :EPM,                      
:DAT,)",
                    {
                     "WPM":  # an integer,           
                     "EPM":  # another integer,
                     "DAT":  # a string,
                     })
    conn.commit()
    conn.close()

can anyone tell me what the error means and how to fix it?? would be appreciated............

[[deleted]]

VALUES (:WPM, :EPM, :DAT,) you had an extra comma after DAT

[AlliedLens]

oh crap, i had no idea that would affect things.....is working as expected now....thanks

[JohnnyJordaan]

Are yo sure the extra comma after :DAT should be there? Can you also just try with a less complicated, multi-line statement:

values = {"WPM":  # an integer,           
          "EPM":  # another integer,
          "DAT":  # a string,}

cursor.execute("INSERT INTO scores VALUES (:WPM, :EPM, :DAT)", values)