How to output an embeded ole object from MS Access database into a ColdFusion 8 form?

ptslv
ptslv used Ask the Experts™
on
I have an Access database with a field type embedded ole object (contains a jpeg image).  How do I output the image into a CFform?  The form is editable, but the image will probably remain static.

ptslv
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2015
Commented:
If the image is are stored in your db,  run a query to get the image bytes
<cfquery name="getImage"...>
      SELECT  TheImageColumn FROM YourTable WHERE ...
</cfquery>

Then display it with cfcontent
    <cfcontent type="image/jpeg" variable="#getImage.TheImageColumn#">

> the image will probably remain static

    The it's usually better to store it on the file system, rather than in a db.

Author

Commented:
Thanks for the help - I appreciate it!

ptslv

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial