Member Avatar for thanadaray

I am trying to update into table if score > 0 but nothing display into table.

if score > 0:
    note = "more"
    update = "UPDATE Sentence SET Note = %s WHERE score = %s"
    c.execute(update, (note[0], score))

Did I miss something?

  • 3 Contributors
  • 3 Replies
  • 80 Views
  • 1 Hour Discussion Span
  • Latest Post Latest Post by thanadaray

Recommended Answers

All 3 Replies

Member Avatar for TrustyTony

Why you put "more" to note but only use the first letter?

Member Avatar for HiHe

Are you sure score is a numeric value?

Member Avatar for thanadaray

I want to update "more" in Note column if score more than 0

Edited by thanadaray
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.