Convert BLOBs to HTML
philg | Posted 3:07am 1. December 2009 Server Time |
Hi Folks,
It's been a long time since I have been active on Haneng but I have hit a problem that I just can't seem to find an answer for and I'm hoping that one of you wonderful people might be able to help me out.
I have a DB with thousands of little Word BLOBs in it. (both in Access and SQL 2000) I am attempting to transfer this to an ASP/SQL web app so that all the BLOBs can be updated and used as HTML instead. The largest BLOB I have found so far is about 500 characters after all the Word file formatting is removed so they should all fit into a large nvarchar field quite happily.
I have spent days trawling though search engines and I just can't seem to find anything that will give me the content in a format that I can use in a web page. If the formating is lost then it would be no big deal, the snippets only use a little bit of bold and some line breaks. However, if this could be preserved then so much the better.
Alternatively, the system I am working on needs to pull many of these snippets into one editable document so if you have any idea on how to do that in ASP I could keep the BLOBS and work with them directly.
Any ideas on how I could do something like this would be gratefully received.
Thanks
Phil |
