Never mind. I figured it out. -d SOLUTION: SELECT * FROM is_activewebmessage WHERE dbms_lob.INSTR(infotext, 'cook') > 0
----- Original Message ----- From: "Deanna Schneider" <[EMAIL PROTECTED]> To: "CF-Community" <[EMAIL PROTECTED]> Sent: Tuesday, August 05, 2003 8:20 AM Subject: OT: searching oracle clobs > So, does anyone know of a good package or custom tag that allows for > searching oracle clob fields? I know there's a way to do it in java, but I > don't really know enough about java to know how to do it with cfobject (we > don't have MX). Seems like someone should have written this already.... > > -Deanna > > > > --------------------------------------------------------- > Deanna Schneider > UWEX-Cooperative Extension > Interactive Media Developer > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=5 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=5 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
