This is semi-old news but it's one of those things I didn't look into until I needed to do it. I'm working on a project right now and decided it would be extremely handy for me to generate a document with cfdocument, and in addition to writing the binary PDF data to the database (long story as to why writing it to disk isn't feasible in this case), I need to send the PDF as an attachment to an email.
Anyway, just thought I'd point it out and also record it here for my own recollection, because I know six months from now I'll forget which project I did this on let alone how to accomplish it. ;-)
Yeah, just make sure your buffer size setting in the DSN is set large enough. Had some large PDF's that were getting chopped and corrupt. This was the last thing we thought of.