Yeps, you have to enable CLOB retrieval and set a max buffer size to get this to work. Actually, I'm guessing you've might have CLOB turned on already and just not have the buffer set high enough. It's rougly max record size in kBytes. Otherwise it will cut your result off.
I had to do it when I was storing PDFs converted from Binary to base64 as long-text strings in a DB table. It worked pretty cool, but only if I had the buffer jacked up to about 1.5MB. Turns out that 30MB of PDF files take up roughly 195MB of space in the DB when encoded and stuffed into a long text field in SQL Server. Then I'd grab the one I wanted and use cfcontent/cfheader to return it as an attachment or inline. Cool test of the technology, but a big consumer of DB space (unless you've got pretty specific needs... a waste.) Laterz, J On Mon, 28 Feb 2005 19:19:50 -0000, Adrian Lynch <[EMAIL PROTECTED]> wrote: > In the CF administrator there's an option to enable long text retrieval. > Make sure that's checked(or unchecked depending on the wording for what it > does). > > Ade4 > -- Continuum Media Group LLC Burnsville, MN 55337 http://www.web-relevant.com http://cfobjective.neo.servequake.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197228 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
