Hi Phil,

What database are you using?  I've written a java cfx tag that supports oracle for use 
with BLOB data that I could send you.

You can also look at this product, its available for different Databases: -

http://web4w3.com/jblob.html

Hth,
Steve

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Stephen Bosworth
Application Development and Integration
Communication and Information Services
The University of Newcastle, Australia
Phone: 02 4921 6574
Fax: 02 4921 7087
Mobile: 0438 492518
Email: [EMAIL PROTECTED]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

>>> [EMAIL PROTECTED] 9/03/2004 11:47:37 am >>>
Hi All,

I know that you are NOT supposed to insert images into a database, however I
really do need to.

I have a CF app that reports via Crystal Reports. One report requires the
printing of an image.

To date, the approach I have taken is to

a) store the image file in a folder
b) when this particular report is required, load the necessary images into a
temporary access db and retrieve them via crystal.

The methodology used to load the images has been to use the CFX_PUTIMAGE tag
that I grabbed off the developer exchange some time ago.

This tag has now decided to fail at one site for reasons not obvious - am
still investigating that.

I am also chasing alternative methods. Can anyone advise on how to load an
image into an access db?

I have seen some posts advising using tobase64 when storing, and tobinary
when retrieving. This won't work in my situation as crystal does not have an
equivalent of the CF tobinary function.

Any thoughts appreciated.

Thanks,
Phil.



---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED] 
To unsubscribe send a blank email to [EMAIL PROTECTED] 

MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004


---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]

MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004

Reply via email to