I built a small, working test application that stored data in a SQL 2k database and then pulled it back out. It was very nifty.
If you would mail me off-list, I can try to find it later. Right now, I'm trying to figure out how to load a 591-column table in SQL 200x. :( BTW, don't let "them" tell you it's wrong to store files in a database and that you should only store the filenames. Many applications store files in databases which makes them extremely portable and easy to manage. (I haven't ready any replies to your message, but those things generally do come out.) M!ke -----Original Message----- From: gabriel l smallman [mailto:[EMAIL PROTECTED] Sent: Saturday, February 19, 2005 8:23 AM To: CF-Talk Subject: Gzip compression and caching system Im working on a tag to wrap around content and then save it to a file, gzip it and serve it out. Expanding on the cf_GZipPage custom tag. But trying to take is a step further. I would like to save the gzip'd binary data in the db. Main reason is the expected amount of gzipped files could be well over 100k. I would prefer to not let the file system handle finding and reading the data. Issue is I cannot figure out how to read the binary data from the db and serve it back out so the browser recognizes the mime type and encoding. Right now the only way I can get it work is if I save the data to a file and: <cfheader name="Content-Encoding" value="gzip"> <cfcontent file="#Attributes.Directory#\#Attributes.CacheKey#.gz" type="text/html"> Anyone have an idea? Or am I stuck with reading it from a file? gabe ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195549 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
