Re: adodbapi and output parameters in stored procedures

2008-11-08 Thread M.-A. Lemburg
On 2008-11-07 17:32, [EMAIL PROTECTED] wrote: Thanks for that excellent pointer! I was able to do just what you said with But if my procedure has an insert statement in its midst, it doesn't work. The cursor.fetchall() gets an exception. Any ideas? Try this (I haven't checked that it

adodbapi and output parameters in stored procedures

2008-11-07 Thread leesquare
Hello, I need some help getting output values from my stored procedures when using adodbapi. There's an example testVariableReturningStoredProcedure in adodbapitest.py, and that works for my system. But my stored procedure also inserts and accesses a table in the database. Here's what I have

Re: adodbapi and output parameters in stored procedures

2008-11-07 Thread M.-A. Lemburg
On 2008-11-07 15:04, [EMAIL PROTECTED] wrote: Hello, I need some help getting output values from my stored procedures when using adodbapi. There's an example testVariableReturningStoredProcedure in adodbapitest.py, and that works for my system. But my stored procedure also inserts and

Re: adodbapi and output parameters in stored procedures

2008-11-07 Thread leesquare
Thanks for that excellent pointer! I was able to do just what you said with But if my procedure has an insert statement in its midst, it doesn't work. The cursor.fetchall() gets an exception. Any ideas? --Li -- http://mail.python.org/mailman/listinfo/python-list

Re: adodbapi and output parameters in stored procedures

2008-11-07 Thread Roger Upole
[EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hello, I need some help getting output values from my stored procedures when using adodbapi. There's an example testVariableReturningStoredProcedure in adodbapitest.py, and that works for my system. But my stored procedure also