Re: Using cursor.callproc with zxJDBC

2007-08-03 Thread Carsten Haese
On Fri, 2007-08-03 at 17:31 +0100, Vaughan V Ashe wrote: > Hi > > We would like to use the store proc. We are using a postgreql > database. what we have working so far is: > > params = [4,4,2] > > curs.callproc("update_job_status",params) > > db.commit() > > #print db > > #print curs.descr

Using cursor.callproc with zxJDBC

2007-08-03 Thread Vaughan V Ashe
Hi We would like to use the store proc. We are using a postgreql database. what we have working so far is: params = [4,4,2] curs.callproc("update_job_status",params) db.commit() #print db #print curs.description result = curs.fetchall() if result == 1: print "good one" else: p