#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2017
    Posts
    10
    Rep Power
    0

    Lightbulb combining 2 tables af a special form


    i want to add **vazne** into another table(it maeans **vazne** will becomes one of the the second table columns )...when i print **vazne** , it returns correct value but as this format : [(360,)]...so when i add it into the second table,
    i get the following error
    Code:
    Exception in Tkinter callback
    
    Traceback (most recent call last):
    
    File "/usr/lib/python3.4/tkinter/__init__.py", line 1536, in __call__
    
    return self.func(*args)
    
    File "/home/pi/start/gui/jus-submeno-image-refreshh.py", line 609, in tozin2
    
    self.whtable()
    
    File "/home/pi/start/gui/jus-submeno-image-refreshh.py", line 645, in whtable
    
    c.execute("INSERT INTO billsf (vaznf, id1, firs1,las1, yekdo, vaznemp) VALUES (?, ?, ?, ?, ?, ?)",(counter, f1, d1, e1, yord, vazne))
    sqlite3.InterfaceError: Error binding parameter 5 - probably unsupported type.]
    **billse** is the first table...**billsf** is the second table... **vazne** is selected based on 2 items in the first second...after calling **vazne** from the first table, it shoud be added to the second table(**billsf**)
  2. #2
  3. Contributing User
    Devshed God 1st Plane (5500 - 5999 posts)

    Join Date
    Aug 2011
    Posts
    5,780
    Rep Power
    507
    Obviously you must either insert into jus-submeno-image-refreshh.py line 644.5 the code vaznf=vaznf[0][0] otherwise do something else.
    [code]Code tags[/code] are essential for python code and Makefiles!
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2017
    Posts
    10
    Rep Power
    0

    ok


    Originally Posted by b49P23TIvg
    Obviously you must either insert into jus-submeno-image-refreshh.py line 644.5 the code vaznf=vaznf[0][0] otherwise do something else.
    thank you very very much.it worked

IMN logo majestic logo threadwatch logo seochat tools logo