ReferenceError: weakly-referenced object no longer exists

Thread Rating:

Thread Modes

ReferenceError: weakly-referenced object no longer exists

deanhystad

Super Moderators

Posts: 6,249

Threads: 16

Joined: Feb 2020

Reputation: 313

Dec-13-2020, 10:10 PM (This post was last modified: Dec-13-2020, 10:10 PM by deanhystad.)

In this line are you trying to pass a tuple?

cur.execute("SELECT * FROM Books WHERE ISBN = %s", (search_words))

If so, the syntax is

cur.execute("SELECT * FROM Books WHERE ISBN = %s", (search_words,))

The trailing comma tells Python this is a single element tuple, not something surrounded by parenthesis.

Messages In This Thread

RE: ReferenceError: weakly-referenced object no longer exists - by deanhystad - Dec-13-2020, 10:10 PM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	Beginner: Code not work when longer list	raiviscoding	2	861	May-19-2023, 11:19 AM Last Post: deanhystad
	local varible referenced before assignment	SC4R	6	1,576	Jan-10-2023, 10:58 PM Last Post: snippsat
	a longer docstring	Skaperen	8	1,724	Aug-25-2022, 11:21 PM Last Post: Skaperen
	UnboundLocalError: local variable 'wmi' referenced before assignment	ilknurg	2	1,948	Feb-10-2022, 07:36 PM Last Post: deanhystad
	Referenced before assignment	finndude	3	3,320	Mar-02-2021, 08:11 PM Last Post: finndude
	IDLE editing window no longer works	chris1	2	2,263	Feb-06-2021, 07:59 AM Last Post: chris1
	Code no longer working	yk303	14	10,339	Dec-21-2020, 10:58 PM Last Post: bowlofred
	UnboundLocalError: local variable 'figure_perso' referenced before assignment	mederic39	2	2,297	Jun-11-2020, 12:45 PM Last Post: Yoriz
	p]Why os.path.exists("abc/d") and os.path.exists("abc/D") treat same	rajeev1729	1	2,201	May-27-2020, 08:34 AM Last Post: DeaD_EyE
	local variable 'marks' referenced before assignment	Calli	3	2,358	May-25-2020, 03:15 PM Last Post: Calli

Users browsing this thread: 2 Guest(s)