Re: Problem With Insert with MySQLdb

2005-11-01 Thread Magnus Lycka
Dennis Lee Bieber wrote: > On Sun, 30 Oct 2005 18:44:32 -0500, "David Mitchell" <[EMAIL PROTECTED]> > declaimed the following in comp.lang.python: >> sql = "INSERT INTO category (category_name) VALUES ('" + >>req.form['category'] + "')" >> cursor.execute(sql) > > Don't do that! >

Re: Problem With Insert with MySQLdb

2005-10-31 Thread Steve Horsley
David Mitchell wrote: > Hello, > > I am a complete beginner with Python. I've managed to get mod_python up and > running with Apache2 and I'm trying to a simple insert into a table in a > MySQL database. > > I'm using the MySQLdb library for connectivity. I can read from the database > no proble

Re: Problem With Insert with MySQLdb

2005-10-31 Thread Sibylle Koczian
Gerhard Häring schrieb: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > David Mitchell wrote: > >>Hello, >> >>I am a complete beginner with Python. I've managed to get mod_python up and >>running with Apache2 and I'm trying to a simple insert into a table in a >>MySQL database. >> >>I'm us

Re: Problem With Insert with MySQLdb

2005-10-30 Thread Gerhard Häring
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 David Mitchell wrote: > Hello, > > I am a complete beginner with Python. I've managed to get mod_python up and > running with Apache2 and I'm trying to a simple insert into a table in a > MySQL database. > > I'm using the MySQLdb library for connect

Problem With Insert with MySQLdb

2005-10-30 Thread David Mitchell
Hello, I am a complete beginner with Python. I've managed to get mod_python up and running with Apache2 and I'm trying to a simple insert into a table in a MySQL database. I'm using the MySQLdb library for connectivity. I can read from the database no problem, but when I do an insert, the value