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

    Join Date
    Mar 2017
    Posts
    13
    Rep Power
    0

    Cool which column of sql table is equal to a variable


    i want to find the value of 'vazn' (one column of sql table) where 'id' column is equal to f1.
    f1 is a variable as following:
    f1=int(enter3.get())
    enter3 is an entry.
    i entered the variable in enter3 that is equal to one of the existing 'id's in the sql table('bills')
    this is my code:
    Code:
    self.cur.execute("SELECT vazn FROM billse WHERE id1='f1'")
                    vaznp = self.cur.fetchall()
                    print(vaznp)]
    i get 'null' when it prints vaznp
    why?????
    please helpppp
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    May 2009
    Posts
    646
    Rep Power
    38
    Your query is searching for the string f1 (literally "f1"), and so will only return records that contain "f1" as you haven't told the database that f1 is a variable and it should use the value that the variable points to. See "Parameterized queries" at SQLite Python tutorial - SQLite programming in Python
    Last edited by dwblas; March 13th, 2017 at 10:34 AM.
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2017
    Posts
    13
    Rep Power
    0

    Exclamation 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**)

IMN logo majestic logo threadwatch logo seochat tools logo