No such column error in python

Question

    db = sqlite3.connect("SQL database")
    cursor = db.cursor()
    query = 'DELETE FROM Item WHERE ItemID = {}'.format(self.ID)
    cursor.execute(query)
    db.commit()
    cursor.close()

unsure why this error is coming up as my code seems to be correct. The error is that whatever value self.ID is the error states that that there is no such column that is that value.

For example self.ID = "hello"

The error would be:

 no such column: "hello"

Any help would be appreciated, thanks

mechanical_meat · Accepted Answer · 2016-02-26 19:03:07Z

1

Your query looks like:

DELETE FROM Item WHERE ItemID = hello

The error message is helpful in this case.

Instead do:

db = sqlite3.connect("SQL database")
cursor = db.cursor()
query = 'DELETE FROM Item WHERE ItemID = ?'
cursor.execute(query, (self.ID,))
db.commit()
cursor.close()

Notes:

The parameter placeholder for sqlite3 is ?.
The parameter value should be the second argument to .execute()
That parameter should be passed to .execute() as a sequence. A tuple is fine.

answered Feb 26, 2016 at 19:03

mechanical_meat

170k25 gold badges237 silver badges231 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Diran Over a year ago

I'm not sure whether this is related to your answer but it says that the current statement uses 1 binding when there are 3 supplied?

mechanical_meat Over a year ago

Ok what is self.ID?

Diran Over a year ago

Sorry, I completely missed this comment, I forgot to add the comma xD thanks for your help though

Collectives™ on Stack Overflow

No such column error in python

1 Answer 1

3 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Linked

Related