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

database questions ala newbie pythonist

2004-12-01 Thread chris
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 question is in the following sma