You were right about the % I'd forgotten. Still, I got the same error. So I
tried to change the command to this:
insert into products (ID, Name, Title, Description, Price, Bedrooms,
Bathrooms, Conditions, Acreage, Construction, Location, Estate, Address,
Furnished, pic1, pic2, pic3, pic4, pic5, pic6) values("1", "name1",
"title1", "descr1", "1.1", "2", "1", "New", "1.5", "new", "princesse",
"princesse", "123 princesse", "Not furnished", "", "", "", "", "", "");
Here's the table description:
(
ID int(3) unsigned primary key auto_increment,
Name varchar(40),
Title varchar(3),
Description varchar(512),
Price float(10,2),
Bedrooms int(1) unsigned,
Bathrooms int(1) unsigned,
Conditions varchar(255),
Acreage float(5,2),
Construction set('New','Existing'),
Location varchar(256),
Estate varchar(60),
Address varchar(100),
Furnished set('Furnished','Unfurnished'),
pic1 blob,
pic2 blob,
pic3 blob,
pic4 blob,
pic5 blob,
pic6 blob
)
Now I get this error:
[Mon Oct 05 13:23:36 2009] [error] [client 66.248.168.98] PythonHandler
mod_python.cgihandler: Traceback (most recent call last):, referer:
http://13gems.com/stxresort/cart/iud.py
[Mon Oct 05 13:23:36 2009] [error] [client 66.248.168.98] PythonHandler
mod_python.cgihandler: File
"/usr/lib64/python2.4/site-packages/mod_python/apache.py", line 299, in
HandlerDispatch\n result = object(req), referer:
http://13gems.com/stxresort/cart/iud.py
[Mon Oct 05 13:23:36 2009] [error] [client 66.248.168.98] PythonHandler
mod_python.cgihandler: File
"/usr/lib64/python2.4/site-packages/mod_python/cgihandler.py", line 96, in
handler\n imp.load_module(module_name, fd, path, desc), referer:
http://13gems.com/stxresort/cart/iud.py
[Mon Oct 05 13:23:36 2009] [error] [client 66.248.168.98] PythonHandler
mod_python.cgihandler: File "/var/www/vhosts/
13gems.com/httpdocs/stxresort/cart/add_edit.py", line 360, in ?\n
add_edit(), referer: http://13gems.com/stxresort/cart/iud.py
[Mon Oct 05 13:23:36 2009] [error] [client 66.248.168.98] PythonHandler
mod_python.cgihandler: File "/var/www/vhosts/
13gems.com/httpdocs/stxresort/cart/add_edit.py", line 314, in add_edit\n
cursor.execute(sql), referer: http://13gems.com/stxresort/cart/iud.py
[Mon Oct 05 13:23:36 2009] [error] [client 66.248.168.98] PythonHandler
mod_python.cgihandler: File
"/usr/lib64/python2.4/site-packages/MySQLdb/cursors.py", line 163, in
execute\n self.errorhandler(self, exc, value), referer:
http://13gems.com/stxresort/cart/iud.py
[Mon Oct 05 13:23:36 2009] [error] [client 66.248.168.98] PythonHandler
mod_python.cgihandler: File
"/usr/lib64/python2.4/site-packages/MySQLdb/connections.py", line 35, in
defaulterrorhandler\n raise errorclass, errorvalue, referer:
http://13gems.com/stxresort/cart/iud.py
[Mon Oct 05 13:23:36 2009] [error] [client 66.248.168.98] PythonHandler
mod_python.cgihandler: OperationalError: (1054, "Unknown column 'Name' in
'field list'"), referer: http://13gems.com/stxresort/cart/iud.py
Is it me, or does this actually make sense?
TIA,
V
On Sun, Oct 4, 2009 at 7:20 PM, Michael Dykman <mdyk...@gmail.com> wrote:
> I assume you are using MySQLdb.
>
> to clarify, I trust you know that this is a tuple:
> (id, name, title,
> description, price, bedrooms, bathrooms, conditions, acreage,
> construction,
> location, estate, address, furnished, pic1, pic2, pic3, pic4, pic5, pic6)
>
> ......
>
> I'm not exactly an expert in python but I don't follow this statement:
>
> > sql = 'insert into products values(%s, %s, %s, %s, %s, %s, %s, %s,
> %s,
> > %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s);', (id, name, title,
> > description, price, bedrooms, bathrooms, conditions, acreage,
> construction,
> > location, estate, address, furnished, pic1, pic2, pic3, pic4, pic5, pic6)
> which is constructed as a = b,c and doesn't do what you think it does
>
> .. if you were looking to do a text sprintf thing, it would be more
> commonly
> sql = 'insert into products values(%s, %s, %s, %s, %s, %s, %s, %s,
> %s,
> %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s);' % (id, name, title,
> description, price, bedrooms, bathrooms, conditions, acreage,
> construction,
> location, estate, address, furnished, pic1, pic2, pic3, pic4, pic5, pic6)
>
> which will not enquote your values. note the '%' operator between the
> string and the tuple.
>
> what you want, I think is the 2 param form of cursor.execute() which
> takes a string statement and a tuple of arguments:
>
> cursor.execute('insert into products values(%s, %s, %s, %s, %s, %s, %s, %s,
> %s,
> %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)' , (id, name, title,
> description, price, bedrooms, bathrooms, conditions, acreage,
> construction,
> location, estate, address, furnished, pic1, pic2, pic3, pic4, pic5, pic6))
> conn.commit()
>
> execute knows how to address the various data types in the tuple and
> will escape/enquote as necessary.
>
> - michael
>
> Since you are
>
> On Sun, Oct 4, 2009 at 2:04 PM, Victor Subervi <victorsube...@gmail.com>
> wrote:
> > Hi;
> > I have the following python code:
> > sql = 'insert into products values(%s, %s, %s, %s, %s, %s, %s, %s,
> %s,
> > %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s);', (id, name, title,
> > description, price, bedrooms, bathrooms, conditions, acreage,
> construction,
> > location, estate, address, furnished, pic1, pic2, pic3, pic4, pic5, pic6)
> > cursor.execute(sql)
> >
> > which, when printed to screen, gives the following:
> >
> > insert into products values ('1', 'name1', 'title1', 'descr1', '1.1',
> '2',
> > '1', 'New', '1.5', 'new', 'princesse', 'princesse', '123 princesse', 'Not
> > furnished', '', '', '', '', '', '');
> >
> > which I can enter into the database directly. However, when I try to do
> it
> > through the script, I get the following error:
> >
> > AttributeError: 'tuple' object has no attribute 'encode'
> >
> > Why is that? There are no tuples here!! Nothing but strings!!
> > TIA,
> > Victor
> >
>
>
>
> --
> - michael dykman
> - mdyk...@gmail.com
>
> Don’t worry about people stealing your ideas. If they’re any good,
> you’ll have to ram them down their throats!
>
> Howard Aiken
>
