DOCX Word document not displaying images when downloaded from a database.

New Here ,
Jan 29, 2021 Jan 29, 2021

Copy link to clipboard

Copied

I'm using ColdFusion 2018, Oracle 12c, and IIS 10.  I setup a page to upload Microsoft Word files with a DOCX file extension into a BLOB field into the database.  When I use the website to open the file all I see is the text.  The problem is I do not see any images that were pasted into the file before it was uploaded. 

 

In IIS there is a MIME Type of DOCX.   

 

The upload query is similar to:

<cfquery datasource="my_dsn">

INSERT INTO my_db_table (

File_Name,

File_Content

)

VALUES (

<CfQueryParam CfSqlType="cf_sql_varchar" value="#File_Name_Value#">,

<CfQueryParam CfSqlType="cf_sql_blob" value="#File_Content_Value#">,

)

</cfquery>

 

The query to get the file from the database is similar to:

<cfquery datasource="my_dsn" name="my_query">

SELECT File_Name, File_Content

FROM my_db_table

WHERE File_Id = "#File_Id_Value#"

</cfquery>

TOPICS
Database access, Documentation

Views

34

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
no replies

Have something to add?

Join the conversation