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
  • 82 Views
  • 1 Hour Discussion Span
  • Latest Post Latest Post by thanadaray
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.