[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.