Re: Inserting an Image

2009-10-16 Thread Victor Subervi
$&1' > > > > > > Another thing to think about is storing image data directly in a database > is often not a good idea. See these links for more info: > > > > > http://mysqldump.azundris.com/archives/36-Serving-Images-From-A-Database.htmland > http://hashmysql

Re: Inserting an Image

2009-10-15 Thread Michael Dykman
> > Regards, > Gavin Towey > > -Original Message- > From: Victor Subervi [mailto:victorsube...@gmail.com] > Sent: Thursday, October 15, 2009 12:05 PM > To: mysql@lists.mysql.com > Subject: Inserting an Image > > Hi; > I have successfully inserted images, like yesterday

RE: Inserting an Image

2009-10-15 Thread Gavin Towey
atabase Regards, Gavin Towey -Original Message- From: Victor Subervi [mailto:victorsube...@gmail.com] Sent: Thursday, October 15, 2009 12:05 PM To: mysql@lists.mysql.com Subject: Inserting an Image Hi; I have successfully inserted images, like yesterday, before into MySQL with the following c

Re: Inserting an Image

2009-10-15 Thread Jo�o C�ndido de Souza Neto
The first thing I think I have to sey is "it´s not a good idea to save image data in a mysql table field", the best way is to save the file in your file system and the file name in the table field, but, if you like to do that, it´s better to be a blob field. "Victor Subervi" escreveu na mens

Inserting an Image

2009-10-15 Thread Victor Subervi
Hi; I have successfully inserted images, like yesterday, before into MySQL with the following code: sql = 'update productsX set pic1="%s" where ID=2;' % pic1 cursor.execute(sql) where pic1 is simply an image uploaded through a form then sent over without any alteration to another (pyth