lensmaker = cur.fetchone()
else:
lensmaker = (maker, )
- #cur.execute("select sn, description, notes, id from lens where maker = ?", lensmaker)
cur.execute(sql, lensmaker)
rows = cur. fetchall()
return rows
lensmaker = cur.fetchone()
else:
lensmaker = (maker, )
- #cur.execute("select sn, description, notes, id from lens where description like ? and maker = ? COLLATE NOCASE", ('%'+pattern+'%', ) + lensmaker)
cur.execute(sql, ('%'+pattern+'%', ) + lensmaker)
rows = cur. fetchall()
return rows