Got the soundex() working. Now when you want to use contains() You need to get the dba to turn on interMedia Text. Not sure what it is, but our DBA told me about it on the way out last night when I was complaining.
Tim -----Original Message----- From: Randell B Adkins [mailto:[EMAIL PROTECTED] Sent: Friday, March 28, 2003 6:45 AM To: CF-Community Subject: RE: SQL Sounds Like Matching try: where soundex(cFirstName) = soundex('tim') use single quotes instead of double quotes >>> [EMAIL PROTECTED] 03/27/03 03:33PM >>> http://info-it.umsystem.edu/oradocs/doc/server/doc/CO20APP/ch10.htm#fnccntn Down the page some they have a decent description of contains. Only problem is I can't get it work like the examples I am seeing in the book. I can use the soundex() function in oracle no problem: Select * from members where soundex(cFirstName) = soundex("tim") When I try to use contains the way it says to like: Select * from members where contains(cFirstName, "Tim") It's throwing an erro sayin gthat the column name is bad, highlighting the word contains in toad. I haven't tried it in SQL+ yet but will do so now that I thought of it :) VarChar2() should be what it's built for. I can't imagine it's going to do clob or blob searches :) Tim -----Original Message----- From: Haggerty, Mike [mailto:[EMAIL PROTECTED] Sent: Thursday, March 27, 2003 3:15 PM To: CF-Community Subject: RE: SQL Sounds Like Matching Tim; Thanks for the response. I am going to get that book. What datatypes can CONTAINS() work against? I am trying it against a varchar2 field and it is giving me problems. M -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, March 27, 2003 3:08 PM To: CF-Community Subject: RE: SQL Sounds Like Matching I got the SQL Server versions difference() and soundex() working in just a few tries. I am working on the oracle kind using contains() with a ! modifier in front of the value your searching against. Oracle 8i The Complete Reference (Oracle Press) has a nice section on all different kinds of advance searches. Turns out you can even do thesauri searches, to look for similar meanings. Crazy huh? Tim ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=5 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=5 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
