SQLite ERROR no such column Python

Question

I have a problem, i am trying to do a validation between a username to that username email by compairing the rowid in python and SQLite, here is the code:

username = self.txtUsername.GetValue()
email =  self.txtEmail.GetValue()
UsernameE  = self.conn.execute("SELECT rowid,* FROM tblPlayers WHERE p_Username="
  + username)
EmailU = self.conn.execute("SELECT rowid,* FROM tblPlayers WHERE p_Email=" + email)

The error is:

> UsernameE  = self.conn.execute("SELECT rowid,* FROM tblPlayers WHERE p_Username="
      + username)
sqlite3.OperationalError: no such column: "what i inserted in the username"

Use indentation rather than backticks for blocks of code. I'd change it but it's too small an edit to be allowed. — Holloway
– Holloway, Commented Jan 9, 2015 at 9:51

Daniel Roseman · Accepted Answer · 2015-01-09 10:48:12Z

1

Your SQL is malformed, because you don't close the quote after the username value. But you shouldn't be doing it that way anyway: you should be using a parameter:

self.conn.execute("SELECT rowid,* FROM tblPlayers WHERE p_Username=? ", (username,))

Also note that execute doesn't return the value: you need to fetch it, eg with fetchone().

edited Jan 9, 2015 at 10:48

answered Jan 9, 2015 at 9:57

Daniel Roseman

602k68 gold badges910 silver badges923 bronze badges

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

3 Comments

user3628517 Over a year ago

it worked but the value of username and email is similar to 0x0316... how do i convert it to the actual string behind this value? tried using fetchone() and fetchall() but i get that sqlite.connection has no attribute for this

Daniel Roseman Over a year ago

You need to get a cursor (cur = self.conn.cursor()) and call both execute and fetchone on that, rather than directly on the connection object.

user3628517 Over a year ago

tried but the return value of each variable is None

DrHaze · Accepted Answer · 2015-01-09 10:00:48Z

0

Try adding quotes to username:

UsernameE  = self.conn.execute("SELECT rowid,* FROM tblPlayers WHERE p_Username = '" + username + "'")

answered Jan 9, 2015 at 10:00

DrHaze

1,31810 silver badges22 bronze badges

Collectives™ on Stack Overflow

SQLite ERROR no such column Python

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related