We would like to outsource all graphics from our Notes Document into a SQL Database. Which means that only the path to the graphic file is saved in the SQL database field.
To select a graphic for the note document, we have to query the SQL database, select the required graphic and the graphic should be included into the Notes document like a HTML Tag.
Is this in general possible? Does anybody have an sollution ideas?
Subject: Embedding of graphics via SQL
Anything is possible you have the time and resources to build it.
If you SQL database is going to give the code or the tag location of the graphic are you still going to have it stored on the server?
Is it general possible? yes, if you ever looked at PHP/MySQL sites they use this concept all the time.
Solution ideas? I, myself, am indifferent to it. Irregardless to the location of the information of where the graphic is found, you are going to have the files located on the webserver (if it is to a different webserver it is a little risque because of the other server could have an outage). What I have seen happen is people use one lotus notes database for all graphics or just a directory structure of the graphics.
But there are many, many ways to accomplish this and there is nothing wrong with having SQL server the location – as long as SQL is going to be up when the HTTP task needs to find the location of the graphic file.
HTH – Cheers – Email in profile.