Solved

Displaying images stored in SQL Server as text

Posted on 2014-10-17
2
195 Views
Last Modified: 2014-12-01
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
Comment Utility
>> 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_
Comment Utility
@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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Recently while working on a project I got a very annoying cfdocument has no body error message. I had never seen this error before. So I checked the code. The code was pretty simple; it was Just showing me the cfdocumnt tag and inside that tag a …
Active Directory replication delay is the cause to many problems.  Here is a super easy script to force Active Directory replication to all sites with by using an elevated PowerShell command prompt, and a tool to verify your changes.
This tutorial walks through the best practices in adding a local business to Google Maps including how to properly search for duplicates, marker placement, and inputing business details. Login to your Google Account, then search for "Google Mapmaker…
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…

763 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now