Edward Muller wrote:
Okay... Saw that
But it doesn't tell me how to get the file into a postgres database though.
Take the content of the file and store it with an ExternalMethod in a BLOB-field... btw: I don't think that Postgres is a good storage for binary-objects... # insertFile.py # from http://www.dzug.org/mailinglisten/zope/archive/2002/2002-11/1037545798840 import psycopg def add_fileobject(self, obj_id, title, file, REQUEST=None): " insert binary file into postgres sql table " # open a database connection o = psycopg.connect("dbname=myDB user=postgres") # create cursor c = o.cursor() c.execute("INSERT INTO TBL_FILES (obj_id, imagetitle, imagedata) VALUES (%(obj_id)i, %(img_title)s, %(data)s)", {'obj_id':obj_id, 'img_title':title, 'data':psycopg.Binary(file.read())} ) # commit on the database connection o.commit() if REQUEST is not None: REQUEST.RESPONSE.redirect('index_html') Cheers, Maik -- Deutsche/German Zope User Group (DZUG) http://www.dzug.org/Members/mjablonski/