I have seen many postings regarding asp. sql and images. One posting
on another group stated that images (jpg, etc) can be called by a db
instead of being stored on the db.

I am asking for some help with coding such a thing. What I want to do
is include in the db the location (url) for the image so I can add it
a pserson's record set and then be able to have it called from the db
to post on a web page.
This is for an awards system.

Thanks for any help.

davestrike (davestrike@nventure.com) writes:
[quoted text, click to view]

I think you have misunderstood something. SQL Server is not able
to invoke an URL. Well, OK, you write an XP or an COM object for the
task, but that would be to retrieve data from the URL into the server.

The usual alternative to storing images within the database, is to
only store a filename (or for that matter a URL), and the you retrieve
that filename to the application, and then the application retrieves
the file.


--
Erland Sommarskog, SQL Server MVP, sommar@algonet.se

Books Online for SQL Server SP3 at