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
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
