Producing content from a database with images

I wish to provide a database into which text can be typed in order to allow customer to export content on a regular basis.  This works fine in Access, exporting table or query using template, but there seems to be no method for images.  I have bodged a solution using a report that generates HTML by text tags closely surrounding a field, but it seems as if they are deliberately making it difficult in Access supporting almost every ole going except gif and jpeg
Any advice on the best solution, not necessarily using access, but I have to pay for any non-Microsoft products, so these are preferred.
LVL 1
daverolfeAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

NickRackhamCommented:
I recently came across the same problem. The quickest and easiest solution is to hold the images in a web folder "photos" as an example and name the photo or image the same number as the record ID in your database. When you call the record from the database you have the ID inserted with .gif written behind it, this then calls the file from the web folder. Without wanting to post another experts answer as my own please look at http://www.experts-exchange.com/jsp/qShow.jsp?ta=asp&qid=10236282 

Hope this helps

Nick
0
daverolfeAuthor Commented:
Thanks for your help and I read the other answer.  This works fine for active server pages, but I don't have that option without paying for different type of web space plus it's an area I don't really wnat to get into for now.  What I want is to be able to create static pages from the database, containing the photo.  As I mentioned earlier I achieved this once using something similar by putting tags into a report as text but it proved unreliable. Any other ideas - are there any other packages anyone has tried that can do this better?
0
PMI ACP® Project Management

Prepare for the PMI Agile Certified Practitioner (PMI-ACP)® exam, which formally recognizes your knowledge of agile principles and your skill with agile techniques.

DreamMasterCommented:
have You tried using OLE objects?
0
mgfranzCommented:
Storing and retrieving BLOB images from a dB is not a difficult thing to do people...

Mark
0
markus_baertschiCommented:
I know a (shareware) tool called gdidb (http://www.gdidb.com)
which would fit the bill.
You seize & modify your data with Access. When necessary
you run the gdidb tool. It will create html files from the data
found in the database.
The html is very customizable (html).
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mgfranzCommented:
There is no need to buy any application, shareware or not.  Storing and retrieving BLOB images is easy with a mirade of methods;

Javascript;

cursorName.colName.blobImage (format, altText, align, widthPixels, heightPixels, borderPixels, ismap)

ASP;

 select PictureID, DATALENGTH(bitmap) as Bytes, Bitmap from Pictures

If you need more info, let me know.

Mark
0
daverolfeAuthor Commented:
This was exactly what I was looking for!  Thanks also to mqfranz who seems to know what he's talking about, but this was the simple solution I was after.
0
mgfranzCommented:
"This is exactly what I was looking for"???  I know of a bunch of apps that will build pages for you out of dB contents.  I just find it easier to write a simple set of functions instead of spending a pile of $$$ on an app that does what I wrote.

But hey, it's your money... If a client came to me and said, "here is $100K, I need a dB driven site...", I would probably do something like you too. :-)
0
daverolfeAuthor Commented:
Fair Comment MG, but with 3 machine to install a day, 4 to build 2 websites and eight (yes 8) children I'll pay the money rather than learn new skills.  Thanks again.
0
mgfranzCommented:
8 children...  In that case, yes, time is money... ;-)
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Development

From novice to tech pro — start learning today.