[Zope] inserting file into external db

[Corbett Waddingham]

1) I'm using ZMySQLDA 1.3.3. According to the link you provided, the
latest version is 2.0.7. I'll check with the person who installed it to
see why the older version was put in.
2)The test files I'm using are all MS Word docs and they are being
output as garbage (mostly \0 with various Unicode characters).
3) DOC_FILE is a Blob. I also tried Text, but that ends up storing the
following: <ZPublisher.HTTPRequest.FileUpload instance at 88315e8> (or
something like it, the reference number at the end changes).

Cory

--- Andy Dustman <andy@dustman.net> wrote:
> 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.
> 


__________________________________________________
Do You Yahoo!?
Spot the hottest trends in music, movies, and more.
http://buzz.yahoo.com/