how to return correct value of update stmt

[eight02645999]

hi
i use odbc to update a table in a database but i always get return
value of -1
even though i tried to return an integer. the table is updated though
....
sql = """
update table
set column = 0
where col = "%s"
select @@rowcount

""" % (var1)
.....
try:
s = odbc.odbc(conne ctstring)
cur = s.cursor()
res = cur.execute(sql )
s.commit()
s.close()
cur.close()
s = None
cur = None
print res
return res
except:
print 'error while processing ', sys.exc_type,sy s.exc_value
how to properly get a positive return ?
thanks

[Steve Holden]

ei***********@y ahoo.com wrote:

hi
i use odbc to update a table in a database but i always get return
value of -1
even though i tried to return an integer. the table is updated though
...
sql = """
update table
set column = 0
where col = "%s"
select @@rowcount

""" % (var1)
....
try:
s = odbc.odbc(conne ctstring)
cur = s.cursor()
res = cur.execute(sql )
s.commit()
s.close()
cur.close()
s = None
cur = None
print res
return res
except:
print 'error while processing ', sys.exc_type,sy s.exc_value
how to properly get a positive return ?
thanks

Is the table actually being updated?

The definition of the cursor.execute( ) method in

http://www.python.org/peps/pep-0249.html

specifically says "Return values are not defined". So if you are seeing
the database do the right thing I'd stop worrying about the return
value. If exceptions aren't being raised and the database is doing what
you want, what's the problem?

regards
Steve
--
Steve Holden [phone] [phone]
Holden Web LLC www.holdenweb.com
PyCon TX 2006 www.python.org/pycon/

[eight02645999]

hi
yes , the table is updated. Just feels "uncomforta ble" with the return
of -1.
was also concerned that what if the actual table doesn't exist, will it
return -1?
anyway, i will go check it out ..
thanks