错误sqlite3.OperationalError:没有此类列：fals

Question

我得到这个错误sqlite3.OperationalError: no such column: false。我尝试过搜索，但对于我这样的新手来说，似乎没有明确的解释和解决方法。在

请帮忙。在

def getViolationsFromCam(self, cam, cleared=False):
        cur = self.con.cursor()
        command = "SELECT camera.location, cars.id, cars.color, cars.first_sighted, cars.license_image, " \
                  " cars.license_number, cars.car_image, cars.num_rules_broken, cars.owner," \
                  " rules.name, rules.fine, violations.time, rules.id" \
                  " FROM violations, rules, cars, camera" \
                  " where rules.id = violations.rule" \
                  " and cars.id = violations.car" \
                  " and violations.camera = camera.id"
        if cam is not None:
            command = command + " and violations.camera = '" + str(cam) + "'"
        if cleared:
            command = command + " and violations.cleared = true"
        else:
            command = command + " and violations.cleared = false"

        cur.execute(command)