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