From d917119235e7b43413e9b191492e0f5f48425cb0 Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Fri, 27 Jan 2006 23:56:13 +0000 Subject: [PATCH] scalar() returns None if no rows --- lib/sqlalchemy/sql.py | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) diff --git a/lib/sqlalchemy/sql.py b/lib/sqlalchemy/sql.py index c3048de294..4ec7cbb7bf 100644 --- a/lib/sqlalchemy/sql.py +++ b/lib/sqlalchemy/sql.py @@ -293,7 +293,11 @@ class Compiled(ClauseVisitor): """executes this compiled object via the execute() method, then returns the first column of the first row. Useful for executing functions, sequences, rowcounts, etc.""" - return self.execute(*multiparams, **params).fetchone()[0] + row = self.execute(*multiparams, **params).fetchone() + if row is not None: + return row[0] + else: + return None class ClauseElement(object): """base class for elements of a programmatically constructed SQL expression.""" -- 2.47.2