select one item from row with sqlite3

Thread Rating:

0 Vote(s) - 0 Average
1
2
3
4
5

Thread Modes

select one item from row with sqlite3

ichabod801
Bunny Rabbit

Team Member

Posts: 4,225

Threads: 97

Joined: Sep 2016

Reputation: 273

Sep-24-2018, 01:08 AM

cursor.execute is expecting a sequence for the second parameter. A sting is a sequence, so it tried to match 'b', 'o', and 'b' to the sql code. Try results = cursor.execute(sql, [name]) instead.

Craig "Ichabod" O'Brien - xenomind.com
I wish you happiness.
Recommended Tutorials: BBCode, functions, classes, text adventures

Website Find

Messages In This Thread

select one item from row with sqlite3 - by mcmxl22 - Sep-24-2018, 12:32 AM

RE: select one item from row with sqlite3 - by ichabod801 - Sep-24-2018, 01:08 AM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	Remove an item from a list contained in another item in python	CompleteNewb	19	6,234	Nov-11-2021, 06:43 AM Last Post: Gribouillis
	Select correct item from list for subprocess command	pythonnewbie138	6	3,556	Jul-24-2020, 09:09 PM Last Post: pythonnewbie138
	Python3 and sqlite3 using AND with SELECT	darktitan	6	3,946	Mar-01-2019, 04:33 PM Last Post: darktitan
	SQL select join operation in python(Select.. join)	pradeepkumarbe	1	2,357	Feb-14-2019, 08:34 PM Last Post: woooee

Users browsing this thread: 1 Guest(s)

View a Printable Version

select one item from row with sqlite3

User Panel Messages

Announcements