>About 12 months ago I came across a site that had a commercial tag for >inserting/retrieving blobs into/from Oracle . I've worn my fingers out >trying to find it again this week and it seems to have disappeared into the >ether. > >I'd really appreciate any info/advice/links/resources.
You shouldn't need a commercial tag. Support for BLOBs, CLOBs and LONG has been included since CF 4.5. CFQUERYPARAM allows you to use SQL bind variables - just make sure you have enabled long text retrieval for the datasource in the CF administrator (it means long binary too, just doesn't say so). I admit, I;ve only used CLOBs and LONG but it *should* work with BLOBs too. I think you'll need to use the Merant Oracle ODBC driver to get it working reliably though, if anyone uses CLOBs with the standard Oracle ODBC driver included with Windows, I'd love to hear from them - I had all sorts of problems which I didn't have time to resolve, so I returned to the good ol' filesystem. Mark ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm ------------------------------------------------------------------------------ To unsubscribe, send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body or visit the list page at www.houseoffusion.com
