See this question from the gadfly faq: http://www.chordate.com/kwParsing/gffaq.html#key -----Original Message----- From: Angietel [mailto:angietel@hotmail.com] Sent: Wednesday, November 29, 2000 10:17 PM To: zope@zope.org Subject: [Zope] Cannot create Primary Key I'm using the Z Gadfly Database as my database adapter, and i using Z SQL Method to create my table, but it is not allow for me to create Primary Key for the my sequence integer field, beside that it also not allow me to create a 'date' data type field. my SQL will be:- CREATE TABLE customer (custno SERIAL PRIMARY KEY, custactdate DATE)
Can anyone help me to I want to know how I can publish images stored in a SQL database. I am trying to create an online photo album that stores images in a database. The features I want to implement are: RetrieveImage, UpdateImage, InsertImage I am running zope on linux mandrake and use ZSever The database I am currently using is MySQL on MySQLDA (MySQLdb non-binary dist.) Mo.
This works with mysql: 1. make mysql table with a LONGBLOB field for holding the image, suppose you make it a field called "imageData" 2. in your DTML, do this (assume getImage gets the image you want) <dtml-in getImage> <dtml-call "RESPONSE.setHeader('content-type','image/png')"> <dtml-return imageData> </dtml-in> The retrieve, etc. things you mentioned are just sql, displaying it is the tricky part! Regards, JJ Mohan Baro wrote:
Can anyone help me to
I want to know how I can publish images stored in a SQL database.
I am trying to create an online photo album that stores images in a database. The features I want to implement are:
RetrieveImage, UpdateImage, InsertImage
I am running zope on linux mandrake and use ZSever The database I am currently using is MySQL on MySQLDA (MySQLdb non-binary dist.)
Mo.
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
participants (3)
-
Farrell, Troy -
Joh Johannsen -
Mohan Baro