python - 错误 : Cursor' object has no attribute '_last_executed

Question

我有这个光标

cursor.execute("SELECT price FROM Items WHERE itemID = ( 
                  SELECT item_id FROM Purchases 
                  WHERE purchaseID = %d AND customer_id = %d)", 
                  [self.purchaseID, self.customer])

我收到这个错误

'Cursor' object has no attribute '_last_executed'

但是当我尝试这个时:

cursor.execute("SELECT price FROM Items WHERE itemID = ( 
                  SELECT item_id FROM Purchases 
                  WHERE purchaseID = 1 AND customer_id = 1)", 
                  )

没有错误。我该如何解决这个问题？

Answer 1

我也遇到过这个问题。我把%d改成了%s，就解决了。希望这对你有用。