That article should work. My system works more or less the same. The sql
datatype needs to be 'text', not 'image'. Cf won't send a binary through
an sql statement. That's why you need to tobase64 it. The result is an
ascii safe string of text. The downside is that the base64 version of
the binary file is ~33% larger.
Gl,
Alexander Sicular
Chief Technology Architect
Neurological Institute of New York
Columbia University
as867 [at] columbia {dot} edu
|-----Original Message-----
|From: Turetsky, Seth [mailto:[EMAIL PROTECTED]]
|Sent: Thursday, January 23, 2003 1:00 PM
|To: CF-Talk
|Subject: tobase64
|
|
|I posted this on another list but didn't get a reply:
|
|I was following this tutorial for storing binary files in a
|database:
|http://is.curtin.edu.au/ics/web/resources/binary_files_with_oracle.htm
|
|I'm using sql server for this which shouldn't matter, but it
|seems my problem is with the toBase64 function, when i run
|that for example on a pdf, I see a lot of +'s and /'s left, so
|when I try to convert back, tobinary fails saying my string
|should be a base64-encoded string. If I manually remove those
|characters, then the tobinary works since it's a valid base64
|string then.
|
|Anyone know why the tobase64 function leaves those characters in?
|
|thanks,
|seth
|
|This message is for the named person's use only. It may
|contain sensitive and private proprietary or legally
|privileged information. No confidentiality or privilege is
|waived or lost by any mistransmission. If you are not the
|intended recipient, please immediately delete it and all
|copies of it from your system, destroy any hard copies of it
|and notify the sender. You must not, directly or indirectly,
|use, disclose, distribute, print, or copy any part of this
|message if you are not the intended recipient. CREDIT SUISSE
|GROUP and each legal entity in the CREDIT SUISSE FIRST BOSTON
|or CREDIT SUISSE ASSET MANAGEMENT business units of CREDIT
|SUISSE FIRST BOSTON reserve the right to monitor all e-mail
|communications through its networks. Any views expressed in
|this message are those of the individual sender, except where
|the message states otherwise and the sender is authorized to
|state them to be the views of any such entity. Unless
|otherwise stated, any pricing information given in this
|message is indicative only, is subject to change and does not
|constitute an offer to deal at any price quoted. Any reference
|to the terms of executed transactions should be treated as
|preliminary only and subject to our formal written confirmation.
|
|
|
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
