Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Displaying images stored in SQL Server as text

Posted on 2014-10-17
2
Medium Priority
?
206 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 1500 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

Simplify Your Workload with One Tool

How do you combat today’s intelligent hacker while managing multiple domains and platforms? By simplifying your workload with one tool. With Lunarpages hosting through Plesk Onyx, you can:

Automate SSL generation and installation with two clicks
Experience total server control

Question has a verified solution.

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

When crafting your “Why Us” page, there are a plethora of pitfalls to avoid. Follow these five tips, and you’ll be well on your way to creating an effective page.
Although a lot of people devote their energy toward marketing for specific industries, there are some basic principles that can be applied to any sector imaginable. We’ll look at four steps to take and examine how those steps were put into action fo…
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…

722 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