Testing with Python if table results are null

Question

 query = "SELECT car FROM cars....."

 cursor.execute(query)

 results = cursor.fetchall()
 for row in results:
      if not query:
           print 'No cars available."
      else:
           print row[0]

What I'm trying to do is print a message if results are null, or print the results if they have entries. The above code is what I have so far but obviously isn't working. Any suggestions?

Thanks in advance.

query is a string defined at the top, so if not query: will never succeed. Try testing row instead? — Tim Peters
– Tim Peters, Commented Oct 8, 2013 at 3:12
Also, you open your 'No cars available." with a single quote, but close with a double quote — SethMMorton
– SethMMorton, Commented Oct 8, 2013 at 3:50

tehsockz · Accepted Answer · 2013-10-08 04:04:19Z

3

If you're trying to print "No cars available" when there are no results:

 query = "SELECT car FROM cars....."

 cursor.execute(query)

 results = cursor.fetchall()
 if results:
      for row in results:
           print row[0]
 else:
      print 'No cars available.'

edited Oct 8, 2013 at 4:04

answered Oct 8, 2013 at 3:21

tehsockz

1,3091 gold badge12 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Testing with Python if table results are null

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related