December 10, 2001 at 2:50 am
Hi!
Can someone help me out with this:
I have an image field populated with data. How is it possible to retrieve this data back (to for example a string variable) from the database with SQL.
Greatful for suggestions
***PLEASE RESPOND TO THE GROUP ****
/John
December 10, 2001 at 1:01 pm
How are you accessing SQL? Via ADO?
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
December 10, 2001 at 3:06 pm
December 10, 2001 at 3:24 pm
ADO is definitely the way to go, use the stream object rather than the old getchunk method.
Andy
December 12, 2001 at 8:27 am
Yes, I'm accessing the database via ADO. Can someone give me code example for how to "decode" the field with the stream object
Help appreciated
/John
December 12, 2001 at 10:54 am
I dont think we have anything on the site yet - try this article from MS:
http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q258038
It's pretty straightforward. Note that if you're doing ASP work, the Response object supports the IStream interface - meaning you can retrieve a blob and dump directly out to the browser without having to write the file to disk.
Andy
December 19, 2001 at 2:57 am
Thx
This article only explains how to handle .jpg files. It doesnt mention anything about "decoding" text from an image field.
December 19, 2001 at 5:01 am
Why wouldnt it work exactly the same way?
Andy
December 19, 2001 at 10:22 am
Should be the same. The client interperts the text v image data. It's all just bits. You can open a jpg in notepad, just looks funny.
Steve Jones
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply