Solved

Displaying images stored in SQL Server as text

Posted on 2014-10-17
2
203 Views
Last Modified: 2017-02-05
I've created a web app in Coldfusion that needs to loop some records and print a form that shows signatures.  The signature image data is stored in a column in a MSSQL database.

The signature field is stored as text (not varbinary or image).  

I've tried every way I know - including URI - to get them to display - no luck.

Anybody have any suggestions?
0
Comment
Question by:Lakin IT
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 
LVL 52

Accepted Solution

by:
_agx_ earned 500 total points
ID: 40387175
>> The signature field is stored as text

AFAIK, the only way it could be stored as "text" is if it were base64 encoded.  

Can you show us the code used to INSERT the image into the db? Then we can help you with how to display the results.
0
 
LVL 52

Expert Comment

by:_agx_
ID: 40474838
@LakinIT - So was it stored as a base64 encoded string?

It's more helpful to the next guy to archive the actual solution, rather than just guesses.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article will inform Clients about common and important expectations from the freelancers (Experts) who are looking at your Gig.
In threads here at EE, each comment has a unique Identifier (ID). It is easy to get the full path for an ID via the right-click context menu. However, we often want to post a short link within a thread rather than the full link. This article shows a…
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question