[Zope] inserting file into external db

Andy Dustman andy@dustman.net
Thu, 14 Jun 2001 13:24:00 -0400 (EDT)


On Thu, 14 Jun 2001, Corbett Waddingham wrote:

> And the SQL to insert the file into the MySQL db (takes argument
> doc_file, DOC_ID is set to 'auto increment'):
> insert into TABLE
> (DOC_ID,
> DOC_FILE)
> values
> ('0',
> <dtml-sqlvar doc_file type=nb>)
>
> The file is showing up, but it's being munged at some point.

1) What version of ZMySQLDA are you using? For latest version see:

http://sourceforge.net/projects/mysql-python

2) Munged in what way?

3) What column type are you using for DOC_FILE?

-- 
Andy Dustman         PGP: 0xC72F3F1D
    @       .net     http://dustman.net/andy
"I'd rather listen to Newton than to Mundie. He may have been dead for almost
three hundred years, but despite that he stinks up the room less." -- Linus T.