<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.6000.16481" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hi </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>We would like to use the store proc. We are using a
postgreql database. what we have working so far is:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT size=2>
<P align=left>params = [</FONT><FONT color=#800000 size=2>4</FONT><FONT
size=2>,</FONT><FONT color=#800000 size=2>4</FONT><FONT size=2>,</FONT><FONT
color=#800000 size=2>2</FONT><FONT size=2>]</P>
<P align=left>curs.callproc(</FONT><I><FONT color=#00aa00
size=2>"update_job_status"</I></FONT><FONT size=2>,params)</P>
<P align=left>db.commit()</P>
<P align=left></P>
<P align=left></FONT><FONT color=#c0c0c0 size=2>#print db</P></FONT><FONT
size=2>
<P align=left></FONT><FONT color=#c0c0c0 size=2>#print
curs.description</P></FONT><FONT size=2>
<P align=left>result = curs.fetchall()</P>
<P align=left></FONT><FONT color=#0000ff size=2>if</FONT><FONT size=2> result ==
</FONT><FONT color=#800000 size=2>1</FONT><FONT size=2>:</P>
<P align=left></FONT><FONT color=#0000ff size=2>
print</FONT><FONT size=2> </FONT><I><FONT color=#00aa00 size=2>"good
one"</P></I></FONT><FONT size=2>
<P align=left></FONT><FONT color=#0000ff size=2>else</FONT><FONT size=2>:</P>
<P></FONT><FONT color=#0000ff size=2> print</FONT><FONT
size=2> </FONT><I><FONT color=#00aa00 size=2>"shite"</FONT></I></P>
<P><I><FONT color=#00aa00 size=2></FONT></I> </P>
<P><FONT color=#00aa00 size=2><FONT face=Arial color=#000000>we are using the
beta version of jython. Would be very happy to get a response from
you</FONT></FONT></P>
<P><FONT color=#00aa00 size=2><FONT face=Arial
color=#000000></FONT></FONT> </P>
<P><FONT color=#00aa00 size=2><FONT face=Arial
color=#000000>Regards</FONT></FONT></P>
<P><FONT color=#00aa00 size=2><FONT face=Arial
color=#000000></FONT></FONT> </P>
<P><FONT color=#00aa00 size=2><FONT face=Arial
color=#000000>Vaughan</FONT></P></FONT></DIV></BODY></HTML>