[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 215
  • Last Modified:

Retrieve image with sql statement based on filename

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
Sebina
Asked:
Sebina
  • 3
  • 2
  • 2
  • +1
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
i would say no...
0
 
lozzamooreCommented:
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
 
SebinaAuthor Commented:
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
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
I know that Access has this feature, but SQL Server doesn't ...
0
 
lozzamooreCommented:
I agree with Angelll
Out interest, what client do you want to run this SQL/view from?
0
 
SebinaAuthor Commented:
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
 
niklausjCommented:
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
 
SebinaAuthor Commented:
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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now