def get_usersId5(self, age, age1, city_id, gen):
with self.connection:
result = self.cursor.execute("SELECT `user_id` FROM `users` WHERE age BETWEEN (?-2) AND (?+2) AND`city_id` = ? AND your_gen = ? AND `is_active` = 1", (age, age1, city_id, gen)).fetchall()
activea = []
for row in result:
activea.append(row[0])
return activea
вот запрос
data['cityTNTF'] = db.get_city(message.from_user.id)
data['genTF'] = db.get_genaF(message.from_user.id)
data['ageAnk'] = db.get_age(message.from_user.id)
ank = db.get_usersId5(data['ageAnk'], data['ageAnk'], data['cityTNTF'], ['genTF'])
Вот обращение
File "C:\Users\lopol\PycharmProjects\pythonProject\server.py", line 284, in cmd_find
ank = db.get_usersId5(data['ageank1'], data['ageank1'], data['cityTNTF'], ['genTF'])
File "C:\Users\lopol\PycharmProjects\pythonProject\db.py", line 208, in get_usersId5
result = self.cursor.execute("SELECT `user_id` FROM `users` WHERE age BETWEEN (?-2) AND (?+2) AND`city_id` = ? AND your_gen = ? AND `is_active` = 1", (age, age1, city_id, gen)).fetchall()
sqlite3.InterfaceError: Error binding parameter 3 - probably unsupported type.
вот ошибка
вот как выглядит бд и данные внутри
буду рад помощи ;)
