MySQL error from Python
Paul M
noway at nohow.com
Sat Jun 26 22:23:19 EDT 2004
That fixed it.
Thank You!
"Dennis Lee Bieber" <wlfraed at ix.netcom.com> wrote in message
news:4r7sd0h1ris3gdsk1ejqeq4gij606pep69 at 4ax.com...
> On Sun, 27 Jun 2004 00:04:54 GMT, "Paul M" <noway at nohow.com> declaimed
> the following in comp.lang.python:
>
>
> > cursor.execute ("UPDATE product SET price = '%s' WHERE
competitorID=1
> > AND sku = '%s'",(myprice,mysku))
>
> Get rid of the single quotes around the %s fields... The
> .execute method should, in theory, determine the data type and needed
> quoting internally.
>
> --
> > ============================================================== <
> > wlfraed at ix.netcom.com | Wulfraed Dennis Lee Bieber KD6MOG <
> > wulfraed at dm.net | Bestiaria Support Staff <
> > ============================================================== <
> > Home Page: <http://www.dm.net/~wulfraed/> <
> > Overflow Page: <http://wlfraed.home.netcom.com/> <
More information about the Python-list
mailing list