I would like to select the first row of a query from a table. This will work
if the query returns valid data:
result = db.select('tablename', where='id=%s' % id)[0]
but throws an IndexError if the query returns an empty dataset.
I can do this:
try:
result = db.select('tablename', where='id=%s' % id)[0]
(...do stuff with result...)
except IndexError:
(...handle error...)
but that seems a little inelegant.
I also tried this:
result = db.select('tablename', where='id=%s' % id)
if len(result.list()) > 0:
(...do stuff with result...)
but that destroys the first iterator so I can't use the result.
Is there a better way to handle this? Ideally, I would like db.select() to
just return "None" if there is no result :)
-Jim
--
You received this message because you are subscribed to the Google Groups
"web.py" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/webpy?hl=en.
