I think that the problem here is that you are dealing with binary data. I
just tried what you had and got the same results.
What I did to get around this is to convert the binary word doc to a string
using the ToBase64() command and then inserting that into the DB. When you
need to retrive the info, get it as a string and then use the ToBinary()
function to convert it bact to a format that word can recognize.
Then write the binary data to a file (like c:\temp\myworddoc.doc) and use
CFCONTENT to present the data to the user (IE users should automagically
open the file in the browser...) and delete the file when done. Lots o
work, but it's functional...
HTH
Jeff Garza
Web Developer/Webmaster
Spectrum Astro, Inc.
480.892.8200
[EMAIL PROTECTED]
http://www.spectrumastro.com
-----Original Message-----
From: Larry Juncker [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 16, 2001 11:22 AM
To: CF-Talk
Subject: RE: Extract Information from a word doc for DB Insertion via CF
Dylan;
I am using the following:
<CFFILE FILE="#FileRoot##Name#" action="READ" variable="FileContent">
with #FileRoot# = f:\websites\larry\aljcompserv\HumboldtMLS\$40k+\
and #Name# = Th - 426 Dear St. $45k.doc
Also I have tried replaceing the first period in the name with CHR(46) and
that did not help. I then renamed the file with taking the pfirst period
out of it.
The template when run results in the following:
f:\websites\larry\aljcompserv\HumboldtMLS/$40k+/Th - 426 Dear St $45k.doc
��ࡱ
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
