Re: database questions ala newbie pythonist

2004-12-02 Thread Steve Holden
Dan Sommers wrote: On Wed, 1 Dec 2004 20:45:13 -0500, "chris" <[EMAIL PROTECTED]> wrote: But when I try to use a variable such as: ### ... varA = '0' varB = '1190' mycursor.execute('Update Categories Set DelStatus = ' varA 'Where Pro

Re: database questions ala newbie pythonist

2004-12-02 Thread Dan Sommers
On Wed, 1 Dec 2004 20:45:13 -0500, "chris" <[EMAIL PROTECTED]> wrote: > But when I try to use a variable such as: > ### > ... > varA = '0' > varB = '1190' > mycursor.execute('Update Categories Set DelStatus = ' varA 'Where ProductID

Re: database questions ala newbie pythonist

2004-12-02 Thread Uwe Grauer
Weinhandl Herbert wrote: chris wrote: ... This works fine using the literals 0 (For Delstatus) and 1190 (for ProductID) But when I try to use a variable such as: ### ... varA = '0' varB = '1190' mycursor.execute('Update Categories Set

Re: database questions ala newbie pythonist

2004-12-01 Thread Weinhandl Herbert
chris wrote: ... This works fine using the literals 0 (For Delstatus) and 1190 (for ProductID) But when I try to use a variable such as: ### ... varA = '0' varB = '1190' mycursor.execute('Update Categories Set DelStatus = ' varA 'Wher

Re: database questions ala newbie pythonist

2004-12-01 Thread [EMAIL PROTECTED]
chris wrote: > Hello, > Just started with python and databases. > I am making a small script to update a local database. > Looked around and couldn't find to many links with info about python with > databases. > Any links or other resources anyone can recommend is appreciated. > > My que