Error: Cursor' object has no attribute '_last_executed

Question

I have this cursor

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

I get this error

'Cursor' object has no attribute '_last_executed'

But when I try this:

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

there is no error. How do I fix this?

I had the same error message, but using the ORM. It turned out to be charset problem solved with encapsulating my string with unicode(). I know it does not answer your question, but it might fit with others that land upon this page in search for answers. — Tommy Strand, Jan 09 '13 at 22:10

score 8 · Answer 1 · answered Jan 23 '13 at 07:01

8

I encountered this problem too. I changed the %d to %s, and it is solved. Wish this is useful for you.

answered Jan 23 '13 at 07:01

bigwind

161
2
8

This worked for me. I guess you have to pass `%s` even for ints. – user2233706 Sep 02 '13 at 04:33

juankysmith · Answer 2 · 2017-02-02T08:26:23.207

The problem is that you are not making substitutions properly in your select string. From docs:

def execute(self, query, args=None):

    """Execute a query.

    query -- string, query to execute on server
    args -- optional sequence or mapping, parameters to use with query.

    Note: If args is a sequence, then %s must be used as the
    parameter placeholder in the query. If a mapping is used,
    %(key)s must be used as the placeholder.

    Returns long integer rows affected, if any

    """

So, it should be:

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

what version of python are you using? – juankysmith Oct 02 '12 at 14:50 — juankysmith, Oct 02 '12 at 14:50

score 2 · Answer 3 · edited Feb 26 '13 at 14:17

2

The reason is that you are using '%d'. When you use '%' in SQL, the execute will interpret the '%' as the format. You should write your statement like this:

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

edited Feb 26 '13 at 14:17

answered Feb 26 '13 at 13:51

muyline

29
3

I'm having the same problem, but documentation for [raw queries](https://docs.djangoproject.com/en/1.5/topics/db/sql/#executing-custom-sql-directly) says to use one `%` for substitution. – user2233706 Sep 02 '13 at 03:44

Pikamander2 · Answer 4 · 2022-02-24T14:52:32.293

2

Depending on your SQL package, you may need to use cursor.statement instead.

edited Feb 24 '22 at 14:52

answered May 25 '20 at 04:08

Pikamander2

7,332
3
48
69

score 1 · Answer 5 · answered Oct 24 '15 at 17:35

1

Worked for me using double %%

  "SELECT  title, address from table t1, table t2 on t1.id=t2.id where t1.title like '%%Brink%%' "

answered Oct 24 '15 at 17:35

Ram

113
1
10

2

For the person who downvoted this, care to explain why? – Ram Jun 09 '16 at 17:00

score 0 · Answer 6 · answered Feb 23 '21 at 18:03

0

from django.db import connection
print(connection.queries)

The code above should display all the requeries that are executed on the request.

answered Feb 23 '21 at 18:03

Luiz Felipe Lima

61
2

Error: Cursor' object has no attribute '_last_executed

6 Answers6

Linked