Using cursor.callproc with zxJDBC

[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:

    print "shite"



we are using the beta version of jython. Would be very happy to get a response from you



Regards



Vaughan
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-list/attachments/20070803/d7d2b0ac/attachment.html>