Hi All
I have created a series of 'fields' all bar the first are obtained from Entries using Tkinter; the first field is serial number generated by the program. These are the lines of code with which I am having a problem:-
def submit_new():
conn = sqlite3.connect('NiCE_book.db')
cur = conn.cursor()
cur.execute("INSERT INTO NiCE_clients VALUES (:f1, :f2, :f3, :f4, :f5, :f6, :f7, :f8, :f9, :f10, :f11, :f12, :f13, :f14, :f15)",
{
'f1', Clnt_Num,
'f2', client_name.get(),
'f3', address_name.get(),
'f4', city_name.get(),
'f5', state_name.get(),
'f6', zipcode_name.get(),
'f7', email_name.get(),
'f8', IP_1_name.get(),
'f9', IP_2_name.get(),
'f10', Keys_ordered_name.get(),
'f11', Order_number_name.get(),
'f12', Date_ordered_name.get(),
'f13', Agent_code_name.get(),
'f14', Client_logo_name.get(),
'f15', Billing_mth_name.get()
})
comm.comit()
com.close()
No matter how I try to express Clnt_Num as a Str,Var, in () in '' etc I get the error ValueError: parameters are of unsupported type.
Hair is being torn out!!!! Thanks for any help.