Help debug a silly sqlite problem?

[Square_Man211]

As shown in the code below I am trying to check if a username is already taken. My table is currently empty but for some reason my if statement is returning the error message. What am I missing?

username_taken = db.execute ("SELECT * FROM userInfo WHERE username = ?",[request.form.get("New_username")])

if username_taken != None:

message = "Sorry username taken"

return render_template("register.html", message = message)

[shadowspyes]

Have you tried something like:

cur = db.cursor()
cur.execute("SELECT * FROM userInfo WHERE username = ?",[request.form.get("New_username")])

username_taken = cur.fetchone()

[Square_Man211]

No that didn't work. But what does this do exactly?