MySQL error from Python

Paul M noway at nohow.com
Sun Jun 27 04:23:19 CEST 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