Solved

Retrieve image with sql statement based on filename

Posted on 2001-06-06
8
208 Views
Last Modified: 2008-07-03
I have a (sql server) database with a table containing logo files of companies. For a better performance only the filename is saved to the table (so it is not a BLOB field). All image files are in the same directory. For example the path is "e:\images" and the filename is in field strPictureLogo of tblCompany. Is it possible to build a sql statement that retrieves the image files, so that the view contains the images?
0
Comment
Question by:Sebina
  • 3
  • 2
  • 2
  • +1
8 Comments
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 6158798
i would say no...
0
 
LVL 7

Expert Comment

by:lozzamoore
ID: 6158827
Do you mean you want the images or just the full path:
If the latter:


select 'e:\images\' + strpicturelogo as logopath
from tblcompany

Cheers.
0
 

Author Comment

by:Sebina
ID: 6159600
I do not mean the full path! I would like to have the image in a view as if the image was in the database.
0
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 6159633
I know that Access has this feature, but SQL Server doesn't ...
0
 
LVL 7

Expert Comment

by:lozzamoore
ID: 6159711
I agree with Angelll
Out interest, what client do you want to run this SQL/view from?
0
 

Author Comment

by:Sebina
ID: 6159792
I want the images to appear on a Crystal Report which is opened from ASP (in a web application).
Since it is not possible to change the path of an image when opening the Crystal Report from ASP (though this is possible from a VB application) I need the images to be included in a view.

Thanks for your comments.
0
 
LVL 2

Accepted Solution

by:
niklausj earned 100 total points
ID: 6160955
in sql 2000 you could write a UDF to pull the File into a temporary blob in sql and include it into a view, but that'll give you a performance far below any blob field natively in the db.
But depending on your needs you can speed up blob stuff if you insert the blobs in a separate table in a different filegroup that you can have in a different file on a different drive.
( Go to DB Properties, Add a DataFile give it a Different FileGroupName, then create table (ID int, Blob image ) on yourFileGroup to send the table to this file)
0
 

Author Comment

by:Sebina
ID: 6244061
So it just seems not possible to add pictures to a view without having the pictures in a (temporary) table. I now have simply saved the pictures to a table directly. Thanks for your help.

Sebina
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to shrink a transaction log file down to a reasonable size.

803 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