Howdi. On Wed, Mar 06, 2002 at 04:31:42PM -0500, Bryan C. Andregg wrote:
I need to be able to store images and the like in a postgres table. It would seem that <dtml-sqlvar> isn't going to be what I want because there isn't a type definition for what I want (the data isn't exactly a string, right?).
I'm reading in the file contents using REQUEST['file'].read(), which works great for ascii text files, but not binaries.
Well REQUEST['file'].read() is ok for binaries, just passing it 1to1 through the database method and adapter may be a bit messy (mixing up sql code aso) so i prefer to encode (e.g. base64) the binary data so it gets "string-compatible" and you can safely insert it into your sql method.
Any help appreciated. -- Bryan C. Andregg Duke University Medical Center Programmer Dept. of Anesthesiology e <bryan.andregg@duke.edu> p +1 919 684 6201
Greetings Christian -- Christian Theune - ct@gocept.com gocept gmbh & co.kg - schalaunische strasse 6 - 06366 koethen/anhalt tel.+49 3496 3099112 - fax.+49 3496 3099118 mob. - 0178 48 33 981 reduce(lambda x,y:x+y,[chr(ord(x)^42) for x in 'zS^BED\nX_FOY\x0b'])