Thanks to everyone for their help. Looks like I've got enough to solve this by changing the Long text type to a CLOB. Good thing I bought a big bag of coffee beans Saturday.
------------------------------------------- Matt Robertson, [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com ------------------------------------------- ---------- Original Message ---------------------------------- From: <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] date: Mon, 17 Mar 2003 16:06:59 -0600 >We use CLOBS with CF5.0 and Oracle 8.1.7 and use CF_SQL_CLOB as the cfsqltype in >cfqueryparam tag. Note we had issues with drivers other than the Native Oracle >driver in CF. > >Doug > >>-----Original Message----- >>From: Dave Carabetta [mailto:[EMAIL PROTECTED] >>Sent: Monday, March 17, 2003 4:49 PM >>To: CF-Talk >>Subject: RE: Text searching in Oracle >> >> >>>Does CF support CLOBs at all? I thought LOB types weren't >>supported? I >>>need to go back to CF 4.5 if I can, but I can restrict the feature to >>>systems running CFMX if need be. >> >>We are successfully using CLOBs on CF 4.5 Enterprise using >>Oracle 8.1.7. >>Just be sure to use CF_SQL_LONGVARCHAR as your cfsqltype with >>cfqueryparam, >>and you'll have no issues. I can't speak for BLOBs though, as >>we don't use >>those. >> >>Regards, >>Dave. >> >> >> >> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
