Was wondering if there is a way to change a boolean from true / false to in / out?
My code below is a boolean switch but I want it to print in or out not 0 or 1
while True:
Tag = raw_input("Please Scan your Tag: ")
q = "SELECT * FROM CARDS WHERE TAG=?"
up = "UPDATE CARDS SET FLAG = (CASE WHEN FLAG=0 THEN 1 ELSE 0 END) WHERE TAG=?"
cursor.execute(q, (Tag,))
cursor.execute(up, (Tag,))
conn.commit()
for row in cursor:
print row [1] + " has been checked " + row[3]
Aucun commentaire:
Enregistrer un commentaire