CF_SQL_LONGVARCHAR has nothing to do with the numeric type long. It is used to describe text fields with a very large number of characters. As he is using Oracle, it will probably be a field of type CLOB (or maybe LONG and then he should switch to CLOB).
-----Original Message----- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: maandag 17 maart 2003 11:50 To: CF-Talk Subject: Re: Text searching in Oracle On Saturday 15 Mar 2003 19:33 pm, Matt Robertson wrote: > Can this be done with CF and one of the other long types, assuming CF > 4.5? MX? Maybe you need to redefine the problem. Why are you trying to do a 'like' on a number ? I ask because http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/server .920/a96540/sql_elements2a.htm#45887 says "LONG columns cannot appear in WHERE clauses" -- Tom C "Land of the free, home of the brave... you have to be brave to live there and enjoy the freedoms" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
