MySQLdb and MySQL stored functions

kurt.forrester.fec at googlemail.com kurt.forrester.fec at googlemail.com
Tue Feb 3 03:55:34 EST 2009


On Feb 3, 8:28 am, Dennis Lee Bieber <wlfr... at ix.netcom.com> wrote:
> On Mon, 2 Feb 2009 23:28:05 -0800 (PST),
> kurt.forrester.... at googlemail.com declaimed the following in
> comp.lang.python:
>
> > However, when I try to use the MySQLdb module it returns an incorrect
> > value (it returns 1).
>
> > I wish to use the DB API 2.0 compliant module for flexibility.
> > Therefore I am trying to work out why the MySQLdb does not return the
> > value as expected (that is as it is returned by the Query Browser).
>
> > Any help would be greatly appreciated.
>
>         Show the code!
>
>         At a rough guess, given the lack of details...
>
>         You forgot to .fetch() the result and are looking at the status code
> from the .execute()
> --
>         Wulfraed        Dennis Lee Bieber               KD6MOG
>         wlfr... at ix.netcom.com              wulfr... at bestiaria.com
>                 HTTP://wlfraed.home.netcom.com/
>         (Bestiaria Support Staff:               web-a... at bestiaria.com)
>                 HTTP://www.bestiaria.com/

Correct diagnosis.

Thanks.

Any ideas on how to suppress the warning output:
__main__:1: Warning: No data - zero rows fetched, selected, or
processed



More information about the Python-list mailing list