Need help with code - thanks!

[buran]

1. you miss closing bracket
2. you never pass your values to execute
try

db.execute("INSERT INTO users (username, password) VALUES (:username, :password)" % (username, password))

[card51shor]

Hey thanks it's almost there but i'm getting this error now :

TypeError: not all arguments converted during string formatting

I'm looking it up as well

[buran]

or

db.execute("INSERT INTO users (username, password) VALUES (:username, :password)" username=username, password=password)

I don't use sqlalchemy, so it's a bit trial and error for me too

[card51shor]

File "C:\school\project1\application.py", line 61
db.execute("INSERT INTO users (username, password) VALUES (:username, :password)" username=username, password=password)
^
SyntaxError: invalid syntax

---

I tried a few options I just can't find the correct syntax. So close! Thanks

[buran]

SyntaxError: invalid syntax

There is missing comma (also in my example)

db.execute("INSERT INTO users (username, password) VALUES (:username, :password)", username=username, password=password)

you may try also

db.execute("INSERT INTO users (username, password) VALUES (?, ?)", (username, password))

[card51shor]

Thanks so much I'm so frustrated trying to figure this out. I tried both your methods and I'm still getting errors. With the first example u gave me, I get this error:

TypeError: get_bind() got an unexpected keyword argument 'username'


And with the other I get this error:

AttributeError: 'tuple' object has no attribute 'keys'

[card51shor]

I fixed the issue with this code:
db.execute("INSERT INTO users (username, password) VALUES (:username, :password)", {"username":username, "password":password})

But now it's entering NULL fields into the database and not what I type into the fields on register.html. Any idea why? Thanks!