Getting error : No results. Previous SQL was not a query. during execution of UPDATE query

Asked Mar 10 '15 at 08:46

Active Mar 12 '15 at 04:50

Viewed 322 times

I know same question has been posted and Answer on stackoverflow. I tried but it is not working with Update Query.

seenQuery = ("UPDATE ChatHistorys SET isRead=1 WHERE isRead=0 AND senderId=5 AND receiverId=1")
q = dbpool.runQuery(seenQuery, ())

During the execution of the above query, I'm getting No results. Previous SQL was not a query.

When I tried with "SELECT" and "INSERT" query, it works perfectly.

query = ("SET NOCOUNT ON;\nINSERT into ChatHistorys (senderId, receiverId,isRead) values (1, 4, 0)")
d = dbpool.runQuery(query, ())

The above code for "INSERT" query, which works fine for me. Then what is the issue with "UPDATE" Query. Any one can help me with this ?

edited Jun 20 '20 at 09:12

Community

asked Mar 10 '15 at 08:46

Mitul Shah

Are you sure there is some data with senderId=5. – Ankit Bajpai Mar 10 '15 at 09:44
@AnkitBajpai yeah data is available, and even when I run same query in sql, it affects 3 rows. – Mitul Shah Mar 10 '15 at 09:56

0 Answers0