Solved

Displaying images stored in SQL Server as text

Posted on 2014-10-17
2
202 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
  • 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

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

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

An enjoyable and seamless user experience can go a long way on an eCommerce site. While a cohesive layout and engaging copy play roles in creating a positive user experience, some sites neglect aspects that seem marginal but in actuality prove very …
Does your audience prefer people in photos or no people? How can you best highlight what you’re selling? What are your competitors doing, and what can you do that is different and unique from them?  Continue reading to learn how to make your images …
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 …
The is a quite short video tutorial. In this video, I'm going to show you how to create self-host WordPress blog with free hosting service.

856 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