Python sqlite3 error

Question

def menuAdiciona():
    nome = input("Digite o nome de quem fez o cafe: ")
    nota = int(input("Que nota recebeu: "))

    if len(str(nome).strip()) == 0:
        menuAdiciona()

    if (nota) == 0:
        menuAdiciona()

    if nota < 0:
        nota = 0

appears this:

Can't convert 'int' object to str implicitly

the input from the user is considered a string, therefore converting it to an int should work OK. Can you please give the rest of the output regarding the error. — KingJohnno
– KingJohnno, Commented Jun 19, 2013 at 18:35
Mostly this error is seen when you try to concatenate a string and an integer: for e.g : '1' + 1 --> TypeError: Can't convert 'int' object to str implicitly, so check your code for such mistakes. — Ashwini Chaudhary
– Ashwini Chaudhary, Commented Jun 19, 2013 at 18:41
print (today) sql = ("INSERT INTO cafe () VALUES ('"+nome+"','"+nota+"','"+data+"')") cursor.execute(sql) cursor.commit() geraMenu() this is the rest — Isaias20
– Isaias20, Commented Jun 19, 2013 at 19:00

jedwards · Accepted Answer · 2013-06-19 18:50:47Z

1

First, the code you provided "works" in Python 2.7 and 3.

A line number or stacktrace would be helpful, but assuming it's in the snippet you provided:

nota = int(input("Que nota recebeu: "))

Here nota is an int.

if len(str(nome).strip()) == 0:

The next line you're trying to cast it to a string without specifying how.

Something like:

if len(("%d" % nota).strip()) == 0:

should prevent the error.

That being said, the line still makes little sense. You shouldn't have to strip() a string representation of an integer.

What are you trying to accomplish with strip() and the if len(...) == 0 parts?

Edit: Lastly, I think you want raw_input() instead of input(), unless you're shadowing that somewhere too.

edited Jun 19, 2013 at 18:50

answered Jun 19, 2013 at 18:37

jedwards

30.3k3 gold badges69 silver badges94 bronze badges

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

1 Comment

Isaias20 Over a year ago

Hey jedwards can you send me an email? I think its more easy send you all my program and you look all. Please, if you have time. [email protected]

Collectives™ on Stack Overflow

Python sqlite3 error

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related