saving and retrieving jpeg or bmp files?

Question

saving and retrieving jpeg or bmp files?

mick burden

SSCarpal Tunnel

Points: 4432
More actions
July 20, 2006 at 5:50 am

#191281

I understand that you are able to save and retrieve picture files to a SQL server, is this correct, if so can someone point me in the direction on how to achieve this? plus is it correct that if you use a stored procedure to retrieve the picture it will wait until the picture is completely "built" before releasing it?

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004365 More actions · Answer 1

Mick,

Yes... you can save pictures in IMAGE datatypes... but it's a really bad thing to do for more reasons than I'd care to post here...

Most folks have seen the light and simply store the path/filename of the picture and pass that to whatever external app that may be available. Is there a reason why you couldn't do that?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

mick burden SSCarpal Tunnel Points: 4432 More actions · Answer 2

It's something I'd like to learn/play around with, even if it's something I wouldn't use

Gabor Nyul SSCrazy Eights Points: 9459 More actions · Answer 3

For performance reasons even I would put those files to the filesystem and store just the path but if security it the main objectiv then you can store the images into the DB (as many document management applications are doing) For this you have to write a client side app which handels the images (in VB, Delphi...) So you can assign the image to the parameter of a stored proc

Bye
Gabor

mick burden SSCarpal Tunnel Points: 4432 More actions · Answer 4

ok thanks, will try and learn how to do it if I can

RyanRandall SSChampion Points: 13623 More actions · Answer 5

Here are a few articles which may help you...

http://www.aspfaq.com/show.asp?id=2149

http://www.dbazine.com/sql/sql-articles/larsen13

http://support.microsoft.com/kb/308042/EN-US/

Ryan Randall

Solutions are easy. Understanding the problem, now, that's the hard part.